| |
| Setting default value for decimal places in the BDE. |
 |
How can I control the number of decimal places in a floating point number when I do a BatchMove to a text file?
Field formats in a text file are stored in a schema file which has the same name as the text file with a .sch extension. When doing a batch move to a text file (batCopy) a .sch file is automatically created. All floating point fields are given a default number of decimal places of 2. After the schema file is created you can edit it and change the number of decimal places to another value. This new value will be used in future batch moves. The default number of decimal places is controlled by the BDE parameter DECIMALDIGITS which can be found in the BDE administrator under: Configuration|System|Formats|Number. Since this is a BDE parameter it can also be changed at runtime by changing the value in the registry at:
HKEY_LOCAL_MACHINESOFTWAREBorlandDatabase EngineSettingsSYSTEMFORMATSNUMBER
|
|
| Hits/month |
2,500,000+ |
Downloads (Since May 2000) |
7,393,709 |
| Total Files |
6,023 |
| Forum msgs |
7,670 |
| Articles/FAQs |
70+/900+ |
Top Selling Software at Amazon
|