>I have an application that does the following:
>
>1. Looks for the existence of a cdx file to a table (in this case, called aging.cdx. The table name is aging.dbf)
>
>2. If the cdx file exists, delete the cdx becuase I want to rebuild the index later in the code.
>
>3. open up the table, write data to the table and rebuild the index.
>
>4. Once all steps are complete, print report and continue with the next record to be processed.
>
>5. The problem is, on all subsequent loops, it gives me the structual cdx not found everytime i try to open the table up without the cdx.
>
>Any ideas? or better ways to handle getting a clean index on a table.
Jeffrey,
I'm not sure whether it 'll help you, but just detach the cdx from the table.
So, don't create it visually but with INDEX ON ... TagName OF CDXFileName.
HTH,
Peter