Rick,
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?

>You can't call Stored Procedures from any ODBC code. The following
>also doesn't work:
>
>

> SELECT SomeStoredProc() fROM DUMMY where recno() = 1
>

>
>I thought it did, but it doesn't <s>...
>
>+++ Rick ---
>
>>Hi Chad...
>>
>>Are you looking for something that limits what updates do and don't go through - similar to what we have in views???
>>
>>My guess is that if something like this is available - it will be exposed in the properties collection of the RecordSet object. What this collection contains and what RecordSets and Connections in general are capable of doing - is determined by the provider.
>>
>>As far as I can tell, we cannot do something like this:
>>
>>oconnection = createobject("adodb.connection")
>>ocommand = createobject("adodb.command")
>>oconnection.Open("testvfp")
>>ocommand.activeconnection = oconnection
>>ocommand.commandtext = '=dbsetprop("view1","view","wheretype",2)'
>>ocommand.execute
>>
>>Perhaps the solution is to create a VFP COM Object that will do this work for you..