>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.
Is it possible the housekeeping code could be running while you're also trying to run the above code?
Could there be lots of other temp files in the temp files folder other than .TMP or .CDX? Try manually cleaning them out if so.
Run CHKDSK on any local drive that might be involved with your app, make sure file system errors aren't causing problems.
Finally, if any antivirus is running, try testing with at least the real-time scanner portion disabled, or any VFP-related folders/files excluded.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up