RAD Studio |  |

Specifying the Table Type for Local Tables
See Also
Collapse All

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

See Also

Controlling Read/write Access to Local Tables

Specifying a dBASE Index File

Renaming Local Tables

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!