Re: Re: Re: TField; number of decimals
Posted by webmaster Guido on March 26, 2001 at 15:03:40:
In Reply to: Re: Re: TField; number of decimals posted by Wim Gijse on March 20, 2001 at 17:31:48:
: : : For a euroconversion checklist, I want to filter all the float fields, with 2 decimals. How do I get the number of decimals defined in the .dbf and .db files? : : : (Total more than 2000 files) : : : Thanks! -------------- It all depends of the storage types that are used in the tables: - if the BCD type is used for a field in a dBASE or a Paradox table, you're lucky: this is the only format for which Delphi can give the number of decimal places (read the "precision" property of a field). - Paradox has a "Money" type of field. Hopefully, the database-programmers used this... The number of decimal places can not be read, but anyway, you know that it is about money :) - for the usual "numeric" type in Paradox tables, there simply is not such a thing as decimal places. - for the "numeric" type in dBASE tables, you only can get the number of decimals by doing a binary read of the table header that contains the structure and by analyzing it. Possible in Delphi, but needs quite some programming.
|
|