>> 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.