Subject | Re: [IBO] Can't save correct values into Numeric Field |
---|---|
Author | Helen Borrie |
Post date | 2001-09-26T09:21Z |
At 03:34 AM 26-09-01 +0000, you wrote:
rgds,
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>HiYou should set its precision to 2 to match what you want to store.
>
>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 findDid you delete the old instance of the persistent field and then recreate it?
>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 haveIf you are certain of this, would you cook up a small demo project, zip it up and send it through to me? Just send the demo project source and the DDL for the table, not a database.
>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 6Also please indicate which version of ib 6 and which dialect you are using.
>and WinNT 4 sp6a.
rgds,
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________