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.
