|
<< Click to Display Table of Contents >> Table file structure |
  
|
|
<< Click to Display Table of Contents >> Table file structure |
|
ADO Data Files (ADF files) are ini files with the following section:
[Table Properties]
Connection=DEFAULT
TableName=EMPLOYEE
MaxRecords=1000
LockType=AdLockOptimistic
CursorType=AdOpenStatic
RecnoColumn=
WhereClause=
OrderByClause=
ColumnList=*
LongFieldNames=0
The section [Table Properties] contains the following values:
| Connection | The name of the connection to use for this table |
| TableName | The name of the table on the server |
| MaxRecords | The maximum number of records to read from the server |
| LockType | The locking type to use (one of the LockTypeEnum values) |
| CursorType | The cursor type to use (one of the CursorTypeEnum values) |
| RecnoColumn | The column to use for record numbers |
| Whereclause | Default where clause that will be used when opening the table. |
| OrderByClause | Default order by clause that will be used when the table is opened in natural order (without index) |
| ColumnList | List of columns that will be selected from the table |
| LongFieldNames | Should the RDD use field names longer than 10 characters |
NOTE
The RDD (for performance reasons) does not validate the SQL statement generated based on the ColumnList, WhereClause and OrderByClause. If your server requires that the columns in the whereclause or orderby clause are included in the Column list, it is up to you to make sure that they are included !!!