Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
How to manually run a procedure with INTERVAL input params? |
Fri, Oct 17 2008 3:23 AM | Permanent Link |
As you know, INTERVAL types haven't equivalent in Delphi and are
converted to Int64. While EDBmgr is written in Delphi, when manually running a stored procedure with some input parameter as interval type, it spects an Int64. But entering any number or interval const raises a conversion error. I think EDBmgr would accept an INTERVAL const as input, say INTERVAL '28:41' HOUR TO MINUTE by example. Only way to test such procedure is hard code input value inside it. Tiago Ameller tiago put_an-a-_in_a_circle sistemasc.net Sistema, S.C. | |
Fri, Oct 17 2008 3:01 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Tiago,
<< As you know, INTERVAL types haven't equivalent in Delphi and are converted to Int64. While EDBmgr is written in Delphi, when manually running a stored procedure with some input parameter as interval type, it spects an Int64. But entering any number or interval const raises a conversion error. I think EDBmgr would accept an INTERVAL const as input, say INTERVAL '28:41' HOUR TO MINUTE by example. Only way to test such procedure is hard code input value inside it. >> I'll see what I can do. The issue is basically as you say - Delphi doesn't have a TParam data type for intervals, which makes it hard to deal with on the Delphi side of things. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |