Because Btrieve does not store any column information in the data file, you may need to define its structure. Tables created by the Btrieve driver or by Scalable SQL will not require this. Utilities are also available from Pervasive Software that will perform this operation.
Database Name: This field displays the directory in which the file you selected in the Define File dialog box is located.
File: This field displays the name of the file that you selected in the Define File dialog box.
Table: Type the name of the table to be returned by SQLTables. The name can be a maximum of 20 characters and cannot be the same as another defined table in the database. This field is required.
Name: Type the name of the column.
Type: Select the data type of the column.
Length: Type the length of the column, if applicable.
Scale: Type the scale of the column, if applicable.