Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving the signature of a stored procedure
Message
 
 
To
02/02/2005 09:38:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00982987
Message ID:
00983052
Views:
24
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform