Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Numeric(9,3) field results in value less than original number encoded

Status
Not open for further replies.

Katisha

Programmer
May 15, 2002
3
PH
In Interbase, a field's data type was numeric(9,3). During entry in database desktop, when we tried encoding ex. 30 in that field, it becomes 29..but this does not happen for all numbers. If you encode 10 or 20, it accepts it but for others it becomes 1 less than original encoded value.

Tried dropping dbgrid, datasource and table components into a blank form. Result was the same with the database desktop example above.

Already ran update pack for Delphi 5. Then tried running it on another computer w/c had same basically same Delphi 5/update pack installation, and exe of project. Only difference was that it was Windows98 (was using NT first time). It ran without any problems!

Cant change the tables anymore, and I dont know how this came about...OS? Delphi installation? Version?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top