Subject | Problem with filed DECIMAL(15,3) |
---|---|
Author | sassicaia70@hotmail.com |
Post date | 2001-09-14T07:00:57Z |
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 !!!)
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 !!!)