|
<< Click to Display Table of Contents >> dBASE NUMERIC vs FLOAT |
  
|
|
<< Click to Display Table of Contents >> dBASE NUMERIC vs FLOAT |
|
The dBASE NUMERIC and FLOAT field types are technically identical, and this way, it is possible (with a dBASE table designer - e.g. Database Desktop and dBASE2019) specifying zero decimals also for FLOAT type fields, which may be meningful when doing maths between fields needing the option to output float value results.
Do not confuse the dBASE FLOAT type with the SQL Float, which is a 64-bit data type specification carrying no dimensions.
SQL Float will with dBASE translate to either NUMERIC or to the dBASE 7 Double (64-bit) type fields, and dBASE FLOAT type fields cannot be specified with SQL.
Screen print from dBASE2019 specifying a dBASE 5 table
Same table as above: dBASE table with FLOAT type fields viewed in PdxEditor
See also Field Types in other apps, dBASE Tables.
__________________________