Hi,

I have a database that exists in Sybase. I have several remote views. One of the views seems to have developed a rather bad sense of humor. When I create it, (using 3 sybase tables) it works perfectly. However, if I were to close down foxpro (VFP 6.0) then go back in later, the view gets locked. Someone here seems to think it uses the correct index upon creation, but then wants to use another index later which causes VFP to hang.

In my advances parameters I share the connection and click the box to retrieve all records.

Has this happened to anyone? If so, how do you resolve this?

Thanks in Advance.

Scott