I want to display a field NUMERIC(18,6) in a pFIBDataSet (with persistent fields) in the currency format. I set the Currency property to True,
Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.
|
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.
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.
===============
During a re-write of a very large software system we were having some difficulties utilizing a 3rd party grid that we had chosen. The dataset connectivity was very flaky due to the complex joins and updates we were using which caused the grids to behave very sketchy. FIBPlus was the perfect solution for us. After implementing it everything became so much easier. The grid functionality stabilized, data retrieval was much faster, and we were pleasantly surprised by many of the unique features of your components. We were especially impressed with your pFIBUpdateObject components which allowed us to very easily update the multiple tables we were using in our joins. Many thanks for your great components.
>>Tracy Anderson, Team Leader, EDSS Division of AADG, Inc.
