--- In IBObjects@yahoogroups.com, "Jerry Sands" <jsands@g...> wrote:

> 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
>
>
>
>

I prepared and opened it and got no error. I'm using Delphi 7 and IBO
4.2Ie. Maybe there's a problem with v4.3.

Stan