Apollo VCL Components > Apollo VCL Component Reference > TApolloQuery > TApolloQuery Properties

Declaration

property TableType: TApolloTableType;

TApolloTableType = (ttSXNONE, ttSXNTX, ttSXFOX, ttSXNSX, ttSXNSX_DBT);

$image\tip.gif$ ApCommon unit must be included in the uses line of any unit containing code that makes direct references to a TApolloTableType value.

Description

Defines the default Apollo data driver dialect to be used to open and update existing tables or to create new tables using CREATE TABLE. Valid types are:

ttSXNONE – Unsuppoted table type (Used by TApolloTable.GetTableType)

ttSXNTX – Clipper (.DBF, .DBT, .NTX)

ttSXFOX – FoxPro (.DBF, .FPT, .IDX, .CDX)

ttSXNSX – HiPer-SIx (.DBF, .SMT, .NSX)

ttSXNSX_DBT - Legacy Clipper DBF/DBT/NSX file combination

All tables opened, created, or updated with TApolloQuery will use the TableType value specified here, unless specifically defined using the TableNames property.

The default TableType value is ttSXFOX (FoxPro).

Delphi Example

ApolloQuery1.TableType := ttSXNSX;

C++Builder Example

ApolloQuery1->TableType = ttSXNSX;