>Steve, I've done exactly what you said to do and my cdx name does not change when I requery a view that has an existing cdx. What version of VFP are you running?
Michael,
VFP 6.0 SP3.
I think you misunderstood my problem explanation. The CDX flle name DOES NOT change with Requery(), but the DBF() file name does. A structural CDX file name must match the table name, which in the case of a view, means the temporary index file name must match the temporary view file name. IOW, DBF() <> CDX(n). To use BEGIN/END TRANSACTION, DBF() must equal CDX(n) in all cases.
Structural CDX files were put into Fox to get rid of index maintenance problems a long time ago, and going back to IDX files is not a solution IMHO.
It has been suggested I reindex. That may be the only solution now, but it is NOT the correct solution. VFP needs to keep its CDXs current, even for views.
Steve Buttress, MCP
ProMatrix MVP - Life
ProSysPlus Developer