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.

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