>Recently a user has reported an intermittant problem that appears to be related to the indexing of a local view. The code in question has been running for years w/o issue. The errorlog is reporting the error as "FILE IS NOT OPEN" and it appears to occur on the INDEX line below:
>
>
SELECT v_myview
>DELETE TAG ALL
>=requery("v_myview")
>SELECT v_myview
>=cursorsetprop("BUFFERING",3)
>INDEX ON UPPER(lastname) TAG lastname
>
>Although the logged error reads "FILE IS NOT OPEN", the view in question is open.... according to the collected list of open tables/views also stored in the errorlog details.
>
>Assuming that the reported error is in fact THE error, I had suspected that a CDX write issue was involved. There's housekeeping code in place that deletes 2 day old *.TMP files from the temp folder (on the user's C drive). However, i realized that the housekeeping code was deleting just TMP files and that a good number of CDX files (now deleted) were still in that folder.
>
>Any ideas?
Why not index it once in the load of the form ? I see no need to delete and recreate the indexes for every requery()
Gregory