Topic complex |
Other functions |
Function |
dat2dbf() |
Short |
Converts a tdb table to dbf file format |
Syntax |
DAT2DBF(FN_DAT : STRING [; LASTFIELD : INTEGER [; MODE : INTEGER]]) : INTEGER |
Parameter |
FN_DAT : path to the dat file
LASTFIELD : highest field index, 0 -> all fields
MODE : 0 -> dbf ASCII formatted, 1 : dbf ANSI formatted
|
Return |
0 : everything is okay
otherwise : Error code
Most significant error codes:
-1 : dbf file could not be created
1: dat table could not be opened
2: Read error
3: Write error
|
See also: |
|
Description |
If the tdbengine table is already open when DAT2DBF is called its current state will be used for the export.
This enables you to define the subset and sequence of the data to be put into the dbf file.
DAT2DBF always generates a dBase IV formatted file which can be processed by FoxPro, too.
Ensure to have MODE set to 1 when you want to work with the export under Foxpro to get the German Umlauts (ÄÖÜäöüß) displayed correctly.
Field types will be to converted accordingly.
Numerical fields will get the predefined amount of decimals.
Memos will be exported, too. The corresponding memo file gets the file extension '.dbt'.
Rename this file to '.fpt' if you want to use it with FoxPro.
Index files are not to be exported.
|