It is probably trying to place the answer in a TParam which Delphi doesn't
support largeints in the TParam object. Use a native IBO component and get
it that way. I do support largeint values with mine.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Patrick Lenz" <patrick_lenz@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, March 21, 2001 5:55 PM
Subject: [IBO] IBOquery & clientdataset problem


> Hi,
>
> The exact same setup works in IBX but I can't get that to work with IBO:
>
> I have the following sproc in IB:
>
> CREATE PROCEDURE SPROC RETURNS( TESTID NUMERIC(16,4)) AS
> begin
> testid = 1;
> suspend;
> end
>
> Now I connect an IBOquery to this and define the SQL:
> SELECT * FROM SPROC
>
> I connect a provider and a clientdataset to this and look at the data
through a dbgrid.
>
> The result is:
> OVERFLOW
>
> ??????
>
> am I missing anything ?
>
> Thanks
>
> Patrick