Subject | Can't save correct values into Numeric Field |
---|---|
Author | pmagor@hotmail.com |
Post date | 2001-09-26T03:34:45Z |
Hi
I have a problem saving numeric values into my Interbase database
using IBO. When I save a value to a field it always saves the value
as 0.2
The field in question is defined in the table as Decimal (11,2) and in
Delphi as a TIBOBCDField with precision of 0 and a size of 8.
I have been looking for a solution on the IBO web page and can't find
one. At first I thought that it was because I was using a TBCDField
in the persistent fields but after the change to TIBOBCDField the
error was still occurring.
In the program I am using the TIBOTable for database access and have
attempted to change the value in the field in code and by using data
aware controls. Using the IB_Monitor dialog it appears that the DBMS
is having the value of 0.2 sent to it.
I am using Delphi 4.03 professional, latest trial version of IBO (v3),
Interbase 6 and WinNT 4 sp6a.
Is there a setting somewhere that fixes this? Or could some one point
me in the direction of some info that could help
Thanks
Peter Magor
I have a problem saving numeric values into my Interbase database
using IBO. When I save a value to a field it always saves the value
as 0.2
The field in question is defined in the table as Decimal (11,2) and in
Delphi as a TIBOBCDField with precision of 0 and a size of 8.
I have been looking for a solution on the IBO web page and can't find
one. At first I thought that it was because I was using a TBCDField
in the persistent fields but after the change to TIBOBCDField the
error was still occurring.
In the program I am using the TIBOTable for database access and have
attempted to change the value in the field in code and by using data
aware controls. Using the IB_Monitor dialog it appears that the DBMS
is having the value of 0.2 sent to it.
I am using Delphi 4.03 professional, latest trial version of IBO (v3),
Interbase 6 and WinNT 4 sp6a.
Is there a setting somewhere that fixes this? Or could some one point
me in the direction of some info that could help
Thanks
Peter Magor