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.