Subject Problem with filed DECIMAL(15,3)
Author sassicaia70@hotmail.com
I have a big problem with field DECIMAL(15,3)

CREATE TABLE "TEST" (
"ID" INTEGER NOT NULL PRIMARY KEY,
"WEIGHT" DECIMAL(15, 3) ,
);


I use IBO 4.2. and IB6 and Delphi 5

I use IBOTable with PessimisticLock = TRUE and I have this problem:

I use one IB_Connection, one IBOTable, one DbGrig.

Source

IboTable1.PessimisticLock := TRUE;
IboTable1.Open;
IboTable1.Edit;
IboTable1.FieldByName('WEIGHT').AsInteger := 99999,999; // OK
IboTable1.Post;
//
IboTable1.Edit;
IboTable1.FieldByName('WEIGHT').AsInteger := 9999999,999; // OK
IboTable1.Post;
//
IboTable1.Edit;
IboTable1.FieldByName('WEIGHT').AsInteger := 99999999,999; // ERROR
IboTable1.Post;


With I have this problem ????

I try with IbConsole - Interactive SQL and don't have this problem ?
Why ????


Someone has ideas....

Thank you ( and sorry for my english !!!)