Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement