>>As long as your DBC is not opened exclusively, the SELECT ... FROM MyDBC.DBC ... WHERE ... INTO CURSOR crsDBCData will select any data from any fields in the DBC into a cursor. THen you can just process the data in that cursor. Other than that, I am a bit confused as to what exactly you are trying to do. There is nothing that will return only the code from a specific procedure stored in the DBC. The SELECT SQL I gave above will return all that code into a cursor where you can use your own set of procedure code to parse through it to get what you want.
>
>You are absolutely right ! I was just going to write that the SELECT FROM myDBC.DBC worked. Thank you Mark for the great help, this will probably prove as the missing link in our effort to make VFP's stored procedures look like other DBMSes, with parameters passed by name. I hope that it will not impact the performance too much and I am looking forward to the coding !
You are welcome. I am pleased that I was able to help you.
Mark McCasland
Midlothian, TX USA