Subject | Re: [IBO]Formatting doubles has broken |
---|---|
Author | Stuart Hunt |
Post date | 2004-04-28T15:29:43Z |
Hi Paul,
I'm not sure for certain whether or not this is fixed in 4.3Ab (I
think it is). however, someone was kind enough to forward me the fix
when I had this problem. If you replace the problematic procedure
with:
The new one is:
var
tmpS: string;
begin
tmpS := AsString;
if tmpS = '' then
Result := 0
else
case SQLType of
SQL_FLOAT,
SQL_FLOAT_: Result := AsFloat;
SQL_DOUBLE,
SQL_DOUBLE_: Result := AsDouble;
else
if SQLScale = 0 then
Result := StrToInt( tmpS )
else
Result := StrToFloat( tmpS );
end;
end;
It should fix it (see message ID 30280 for more info).
HTH,
Stuart Hunt
I'm not sure for certain whether or not this is fixed in 4.3Ab (I
think it is). however, someone was kind enough to forward me the fix
when I had this problem. If you replace the problematic procedure
with:
The new one is:
var
tmpS: string;
begin
tmpS := AsString;
if tmpS = '' then
Result := 0
else
case SQLType of
SQL_FLOAT,
SQL_FLOAT_: Result := AsFloat;
SQL_DOUBLE,
SQL_DOUBLE_: Result := AsDouble;
else
if SQLScale = 0 then
Result := StrToInt( tmpS )
else
Result := StrToFloat( tmpS );
end;
end;
It should fix it (see message ID 30280 for more info).
HTH,
Stuart Hunt
--- In IBObjects@yahoogroups.com, "Paul Hope" <paulhope@a...> wrote:
> Hi Helen
>
> >>Having upgraded to 4.3Aa I now have a problem which wasn't there
before.
>
> >Have you installed the IBO_4_3_Ab_test.zip (preview of sub-release
patch)
> >yet?
>
> >Helen
>
> No - I wouldn't normally install something with a name like that.
Does it
> fix this problem?
>
> Paul