General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only