Try creating IDX index files, not keys in a compound index file, as in INDEX ON primarykey TO myindex.IDX. When you requery the view, recreate or reindex the index.


>I have run into a problem witht he way VFP names Views and View CDXs. To recreate my observation create a simple view on any table. Then look at its name with DBF(). the result will be a temproray, generated file name like "G4DW000R.TMP" Now index the view on any field and check the index file name with CDX(1). The result should be "G4DW000R.CDX", and should have the same path as the view file name, which should be the path to your temp directory.
>
>Now, Requery() the view, and check the names as above. You will find the view file name has changed, but the CDX file name has not. OOPS, now we have a NON-STRUCTRUAL CDX! Now add a tag to the view, and check the name again. The condition now is even worse, as you will have a structural and a non-structural CDX. Repeat the steps a couple of times, and you start get a real mess.
>
>In an APP, the user is working away, and the APP calls BEGIN TRANSACTION prior to updating. ERROR 1548. Too many non-strucural indexes open.
>
>has this been noticed by MSFT before? Is there a fix or workaround?
>
>Thanks for any help.