>Steve, when I open a view and create a compound index and then requery, the dbf and the cdx names DO NOT change.
>
>This is the code I used to test.
>
>*-Open the view
>USE Nothing_vw
>INDEX ON Nothing_vw_key tag Nothing_vw_key
>
>?DBF()
>?CDX(1)
>
>=REQUERY
>
>*-The same name for the dbf and cdx
>?DBF()
>?CDX(1)
Michael,
Here is my test code.
USE cmi!lv_vendors
INDEX ON cid TAG primary
? DBF() && = F5PW000M.TMP
? CDX(1) && = F5PW000M.CDX
= REQUERY()
? DBF() && = F5PW000Q.CDX
? cdx(1) && = F5PW000M.CDX
Note the last character of the temp name in the DBF() after the Requery().
Steve Buttress, MCP
ProMatrix MVP - Life
ProSysPlus Developer