Sorry, I had gotten a article about it but I couldn't found it for you. If you have UT premium rights, I think so you can found it.

SQL server process your commands in a queue. if you use a server side fetch, your select command not ended until you end the fetch. If you try another sql command with same handle you'll see your server's all station will locked!.. It's strange but, true. It had reasoned me a big trouble. I can't forget my scary movie. :)

As in Fabio's message's "reccount()" function will force VFP's to read all records on cursor and it ended your fetch like my "go bottom" advice.

>I appreciate the response; could you elaborate on 'fetched handles' and why not to share them?
>