Table specifications

Default database file extension

ADF

Maximum Number of fields

1024 (*)

Maximum Record Length

n/a (*)

Maximum Records in a RecordSet

2^31 (0x7FFFFFFF) (*)

Maximum File Size

n/a

Record Locking

Handled by OleDb Provider

Index specifications

Default index file extension

ADX

Number of orders/tags per file

unlimited

Maximum number of index files per workarea

15 (*)

Maximum key Length

256 (*)

Maximum length of key expression result  

240 (*)

Production/structural index support

Yes

Data types allowed for key expressions:

 date

yes

 numeric

yes

 string

yes

 logical

no

 memo

no

(*) This may be limited by the OleDb provider