Hey John,
I agree with everything you said. The thing is, can I effect the way ADO creates its where clause when I say "RS.UpdateBatch". It's not really an issue of what the backend supports.

>Hi Chad...
>
>Now I am finally able to jump in here....
>
>This has been the biggest problem - when discussing ADO, or C/S in general. Yes, stored procs are powerful. When you talk about SQL Server, you are on solid ground. With Fox, well, it is not a server database period. Unless of course, you want a 3.8 mb ODBC Driver. Then, stored procs could be supported. This is why I refuse to demo ADO anymore with a VFP backend. At some point, you are going to hit limitations.
>
>What VFP needs is an OLE-DB provider with the support for the most essential commands. You can't have it all - otherwise, we are talking about a big OLE-DB provider.
>
>This too gets back to my point about providers. ADO is just an interface - nothing more. What you are able to do is 100% dependent on the provider. If you were not able to do something with VFP using SPT - no way you are magically going to get those capabilities with ADO. You do however, get a much better interface. It does however, come at the expense of not having a native VFP cursor to work with...
>
>
>>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.