I am having a problem TIB_Query that calls a stored procedure that returns 5
floats. When the TIB_Query has the Display Format set to “,0.00” and a
non-zero result is returned for one of the floats I get a “12.3456783294678
is not a valid integer value.” Error. It is easily reproducible by just
creating a stored procedure as follows:

CREATE PROCEDURE TESTFLOAT
returns (F1 FLOAT,
F2 FLOAT,
F3 FLOAT,
F4 FLOAT)
AS

begin
F1 = 0;
F2 = 0;
F3 = 0;
F4 = 12.345678;
SUSPEND;
end

Then with a TIB_Query put in the SQL:

SELECT * FROM TestFloat

Set up F1 – F5 to have “,0.00” (or any format that formats the result to a
non-integer value). Try to prepare and open the dataset right from the
Query dialog and you should get the error message.

It appears that IBObjects is not correctly determining the column type from
a stored procedure.

I am using Delphi 7 and IBObjects V4.3Aa.

Thanks

Jerry Sands




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