>HAving trouble with several requeries in code that lock up VFP where the NT task manager must end the session. I use only remote views against SQL 7.0 backend. From the project data tab and remote views, I can run the parameterized views with no trouble. Inside a method that does a REQUERY('') will lock up VFP tight. The connection is not shared. I turned ODBC trace on to log any ODBC transactions right before the requery and there are none. There are only 6 other connections to the SQL server at the time. I have tried the same code on different SQL servers with the same data and get the same lock up.
>
>Does anyone know of any REQUERY() lockup problems with Remote Views??

Just a shot in the dark here, but I had a similar problem [not a lock up, but always got a connection busy error] when selecting a single row from a 1-row table in Oracle. The problem occurred when I set the FetchSize property of the view to 1 [retrieve 1 record at a time]. This seemed logical to me because the table only had 1 record. When I set the FetchSize to -1 [retrieve all records], the error went away, and the 1 record was retrieved.