Mega Code Archive

 
Categories / Delphi / ADO Database
 

Ttable addindex[] with ixunique and paradox tables

Question: Why can't I use the ixUnique option when creating indexes for Paradox tables with the AddIndex method of the TTable component? Answer: The index options used in the AddIndex method of the TTable component are table specific. For example, the ixUnique option works with dBASE tables but not Paradox. The following table shows how these options apply to dBASE and Paradox tables. Index Options dBASE Paradox --------------------------------------- ixUnique * ixDescending * * ixNonMaintained * * ixPrimary * ixCaseInsensitive *