Whoa there, Stephen! Why jump to the conclusion that I'm pulling down an entire table? I'm not, don't worry. (Well I may have been in this one little test - I'm not looking at the code right now - but the backend table only has a couple of records or so - that's definitely not something I'm doing normally.)
I'll try the GO BOTTOM and see what happens. Feel free to take a stab at the other question I posted in the same Client/Server category. Thanks for the reply and I must say that I like your last name.
Russell
>>I'm converting a program to use SQL Server on the back end and I've written a test program to ensure that I can talk to SQL Server, fill cursors, make changes, and save the changes to the back end. The program opens the tables, populates some cursors and does some tableupdates. If I just let it run, it gets to one point and says the cursor does not exist, but if I step through it, it works fine. I can reproduce this at will. So it's like VFP is too fast for SQL Server. It's expecting the cursor to be filled, but it isn't. Will I have to put delays in this program to let SQL Server finish its job? Anyone seen this before?
>>
>
>Add a go bott statement for all your cursors your returning from the server. You think your getting alot of data, VFP does, but it's not.
>
>That should fix it.
>
>Oh and are you pulling entire tables from the back end? If so, STOP THAT. This is now client server and no longer xBase.