>I have an index routine that uses a KEYS.DBF file. This file contains the filename, index name, key expression and Ascending/Descending indicator.
>
>Is there a way to populate this file by reading the .dbc directly?
>
>Ideally, I'd like to run "LoadKeys()" at app startup as well as intermittently during development.
>
>TIA
Larry,
BTW VFP compared to FP2.x also has primary(), candidate() etc. + more enhanced functions like "alter table ... foreign key ...".
Also a shortcut to all this is to generate programatic form of DBC with gendbc or gendbcx (www.stevearnott.com) and use it.
Cetin