Only time I've seen this sort of behaviour is while a grid or browse screen is refreshing.
Let's say you have a window active and some code executing after the window closes. If there is a browse window, or perhaps a grid, being refreshed, simply by virtue of it becoming the active screen Fox may change the selected table on you right in the middle of your executing code!


>All,
>
>We have encountered an intermittent problem with one of our major applications. This application is "mission critical" and runs 7X24. It is installed at a number of sites on NT 4 servers each with two or three data entry/browsing clients. We are using VFP 6. The NT is a file server. However, there are some VFP data loading applications that run on the server too.
>
>Recently at the site with the largest database (60 Meg, 33,000 records)we have experienced strange behaviour in code that has been running day-in, day-out for many months.
>
>The symptom is that when a database is selected in fact a prior selected one is selected instead. This appears to happen on the NT server and we have just encountered it on a client Windows 95. There are about 10 databases active.
>
>On this client we have now proved the following code (snippet) works
>
>select aliasname
>if used("aliasname")
>select
>end if
>
> ...... other stuff
>
>BUT
>
>select aliasname
>
> ...... other stuff
>
>ends up selecting the wrong database.
>
>Does anyone have any ideas?
>
>Regards
>
>Richard Schneller
>Director, Synergistic Systems