[SOLVED] About $ and Cents - Dbf Level 7

[1HuntnMan]

I'm at a part on a project designing Proposals and Sales Orders.  I designed the database with TDbf Level 7.  I'm looking for a suggestion on handling money value fields.  Project Est. and Commission.  Actually the display and save fine as long as I don't enter Cents, i.e. 500.58. Stores in the table field value and changes as you enter to 501.
Should I or can I changes these field from Float to Currency?

[Fibonacci]

Store money values in cents

[1HuntnMan]

So, the DataField is PRICE (FLOAT). Decimals is 2 and DisplayFormat is $0.00.  If I key in 55.25 and tab to the next field is displays $56.00.
so you are saying to store as .5525 correct?

[Fibonacci]

I dont know much about Tdbf, but if this database doesnt have data type like DECIMAL in MySQL then just use ftLargeInt I guess, then multiply your money value by 100 and save; then read and divide by 100, so you have no floating point errors.

55.25 = 55.25 * 100 = 5525, no floats

[1HuntnMan]

Okay, that makes sense.  I've been thinking of just converting this app to SQLite but it would be quite an overhaul.  I used TDbf because this system will probably never be more than a 2-3 users, mostly 1 user because it's a Photography Mgt. System for photographers. Thanks for the wake up call! Take care ...

[1HuntnMan]

Yes, also I had these fields setup as Float.

[wp]

I'm at a part on a project designing Proposals and Sales Orders.  I designed the database with TDbf Level 7.  I'm looking for a suggestion on handling money value fields.  Project Est. and Commission.  Actually the display and save fine as long as I don't enter Cents, i.e. 500.58. Stores in the table field value and changes as you enter to 501.
Should I or can I changes these field from Float to Currency?

You could try to add this after opening the dataset (assuming that the field is created as float field):

Code: Pascal  [Select][+][-]

1.   TFloatField(Dbf1.FieldByName('Value')).Currency := true;

[1HuntnMan]

WP, that's the easy way and works a lot easier than calculating as folks enter data. Thanks