Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Retrieving the signature of a stored procedure
Message
 
 
À
02/02/2005 09:38:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00982987
Message ID:
00983052
Vues:
23
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform