I can see where the confustion is now. All along I have been talking about SQL server back. I've been tring to build a middle tier that converts ADO record sets (populated from SQL server) to VFP cursors. I then update the record set with values from the cursor and call rs.updatebatch. I can't seem to be able to control the concurrency constrants. Sorry about the confusion there.

>Well, duh...
>
>Of course it works against SQL server. It doesn't work with VFP
>stored procedures...
>
>+++ Rick ---
>
>>Ooops I used greater then and less then signs that should have been:
>>
>>>nHandle = sqlconn('dsn name')
>>
>>>>> I'm not sure what you mean by this. In Fox we can call SP's through pass through and I think you can call an SP through the ADO command object. Why would you ever put a select and from clause on a SP? SP's are pretty much procedures like in Fox. You have parameters and return values. Maybe I'm just missing your point?
>>>>
>>>>How?
>>>>
>>>>It doesn't work for me and when I asked about this at MS a while back
>>>>I was told it's not supported.
>>>>
>>>>+++ Rick ---
>>>
>>>It works, just do:
>>>
>>>nHandle = sqlconn('')
>>>? sqlexec(nHandle,"sp_who")
>>>
>>>This will return the results of sp_who to a cursor. You can also call any other SP you want. I tried a few of the sample ones that come in the Northwind database on SQL 7.0. I have not tried it through ADO yet.

Chad Gronbach
Blackstone, Inc.