Question: I use Delphi 7, TpFIBDataSet 6.5.0 Release and Firebird 2.0. I have a field NUMERIC(18,6) in a pFIBDataSet (with persistent fields) and I want to display this field like the currency format. I set the Currency property to True, but the field is not displayed in the currency format. The field is displayed as "1.000000".

Answer: Please check the TField.DisplayFomat property. It must be empty.

======Cut from Borland help==========

Use the Currency property to specify the formatting of the field for viewing and editing in a data-aware control.

The field is formatted for display using the DisplayFormat property if it is assigned. If DisplayFormat is not assigned, Currency determines how the field is formatted for display. If Currency is True the value is formatted for display using the FloatToText function with the ffCurrency formatting code. If Currency is False, the value is formatted with the ffGeneral format.

The field is formatted for editing purposes using the EditFormat (or DisplayFormat) property if it is assigned. If neither EditFormat nor DisplayFormat is assigned, Currency determines how the field is formatted for editing. If Currency is True, the value is formatted for editing using the FloatToText function with the ffFixed formatting code. If Currency is False, the value is formatted with the ffGeneral format.
===============


Preview text: 
Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...

Navigation



What a good job you did! Keep coding great pieces of fast and efficient software:) We started using FIBPlus back in 2001. Since then, every project we offer uses FIBPlus to connect to FirebirdSQL. You library has always been stable, flexible and rocket fast ! Our major project, an helpdesk/data mining application, concurrently used daily by more that a hundred technicians and analysts, uses FIBPlus. Now that FirebirdSQL 2.0 is available, we have been able to upgrade our application quickly and painlessly - that's another reason you can be proud of your work ! >>

Benoit Le Bourhis, Adhoc Innovations
FOR CUSTOMERS
Download full versions and updates in your Personal Area