Subject | NUMERIC(18,2) and TIB_Grid error... |
---|---|
Author | Dmitry Beloshistov |
Post date | 2002-06-27T11:22:24Z |
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@...
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@...