Specifying the Table Type for Local Tables

From RAD Studio
Jump to: navigation, search

Go Up to Using BDE-enabled datasets Index

Note: The Borland Database Engine (BDE) has been deprecated, so it will not be enhanced. For instance, BDE will never have Unicode support. You should not undertake new development with BDE. Consider migrating your existing database applications from BDE to dbExpress.

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