>one of my office prg need to change table data by manual monthly ( to add a set of new data into it), but after i modify the database and re-index it once, and replace the old one, the prg can't find the tag of index expression inside the cdx index file, and i use VSvfp 6.0 to open the table, i can't view the index file info. and i need manual open the cdx index file. is that the problem that i modify the table and the cdx index file will no longer be related to this table ?!
Wai,
CDX doesn't mean it would be opened by default. If you want to open and update by default than let them have the same name as the table and table be marked as a table with "structural" index file. The easiest way to the it, when you create the table (or modify an existing) create the indexes in the designer. Of course you could do it outside of the designer w/o specifying a CDX file.
Cetin