Specifying the Table Type for Local Tables
Go Up to Using BDE-enabled datasets Index
If an application accesses Paradox, dBASE, FoxPro, or comma-delimited ASCII text tables, then the BDE uses the TableType property to determine the table's type (its expected structure). TableType is not used when TTable represents an SQL-based table on a database server.
By default, TableType is set to ttDefault. When TableType is ttDefault, the BDE determines a table's type from its filename extension. The following table summarizes the file extensions recognized by the BDE and the assumptions it makes about a table's type:
Table types recognized by the BDE based on file extension
Extension | Table Type |
---|---|
No file extension |
Paradox |
.DB |
Paradox |
.DBF |
dBASE |
.TXT |
ASCII text |
If your local Paradox, dBASE, and ASCII text tables use the file extensions as described in the previous table, then you can leave TableType set to ttDefault. Otherwise, your application must set TableType to indicate the correct table type. The following table indicates the values you can assign to TableType:
TableType values
Value | Table Type |
---|---|
ttDefault |
Table type determined automatically by the BDE |
ttParadox |
Paradox |
ttDBase |
dBASE |
ttFoxPro |
FoxPro |
ttASCII |
Comma-delimited ASCII text |