Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Retrieving the signature of a stored procedure
Message
De
02/02/2005 08:48:51
 
 
À
02/02/2005 05:52:14
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:
00983014
Vues:
15
After looking more closely to the VFP data dictionary, it looks like I have been a little too optimistic. All there is in the data dictionary is a record with OBJECTTYPE="DATABASE", OBJECTNAME="STOREDPROCEDURESSOURCE", and CODE a Memo field supposed to contain the code for all stored procedures.

So the following looks like a good strategy : having custom tables (sp and spparam) to maintain the information about the stored procedures and their parameters. Those tables would be written during the AfterAppendProc or AfterModifyProc events, just by analysing the code. A great benefit of that approach would be that useful documentation information could be collected in the same time.

But there is a but : how can I access the CODE field of the data dictionary ? According to the doc, DBGETPROP doesn't seem to allow this.

Any help will be greatly appreciated, as that was supposed to be a cornerstone of our architecture.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform