Subject | IBOquery & sproc & clientdataset problem |
---|---|
Author | Patrick Lenz |
Post date | 2001-03-22T00:54:22Z |
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
[Non-text portions of this message have been removed]
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
[Non-text portions of this message have been removed]