Thanks Geoff,
There is no exception. If I select from a storecproc and return numeric(16,4) the dbgrid behind the clientdataset shows zero's or overflows instead of the numbers. Even if the numbers are small integers, they show up as zero.
I could email you a small testapp but it is really just dumping a iboquery, a provider and a clientdataset on a from and select * from the storedproc.
If I do this with IBX or Tquery I have no problems at all. When I look at the results at the sql-editor at iboquery they are OK !?!.
The strange thing happens when IBOquery moves the data over to the provider/clientdataset.
regards
Patrick

----- Original Message -----
From: Geoff Worboys
To: IBObjects@yahoogroups.com
Sent: Thursday, March 22, 2001 3:48 AM
Subject: Re: [IBO] IBOquery & sproc & clientdataset problem


Patrick,

> CREATE PROCEDURE SPROC RETURNS( TESTID NUMERIC(16,4)) AS
<...>
> The result is:
> OVERFLOW
>
> ??????
>
> am I missing anything ?

I am not familiar with the TIBO* stuff. But perhaps if you can post
the callstack from when this exception is raised it may help pin down
the problem.

Geoff Worboys
Telesis Computing


Yahoo! Groups Sponsor

Click Here to Find Software Faster


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]