Subject NUMERIC(18,2) and TIB_Grid error...
Author Dmitry Beloshistov
Hello,All !

Check this test (FB 667 on Win32):

Table create script:
//--------------
CREATE TABLE TESTTABLE
(
TESTFIELD NUMERIC(18,2)
);
//--------------
//- data insert example
with IB_Query1 do
begin
sql.add('INSERT INTO TESTTABLE (TESTFIELD) VALUES(?AVALUE)');
Prepare;
ParamValues['AVALUE']:=9999999999999999.99; // max value for
NUMERIC(18,2)
ExecSQL;
//- success, data was inserted
end;
//-- another code here .....
//- and after :
with IB_Query1 do
begin
sql.add('SELECT * FROM TESTTABLE'); Open;
end;

We have "INT64 overflow" exception (and may be forever cicle?) in TIB_Grid
on record, what contains big value (all another - success, any
exceptions)...
Any suggestion?

WBR, Dmitry Beloshistov AKA [-=BDS=-]
e-mail: torin@...