RAD Studio
ContentsIndex
PreviousUpNext
Specifying the Table Type for Local Tables

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  
Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!