Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving the signature of a stored procedure
Message
From
02/02/2005 08:48:51
 
 
To
02/02/2005 05:52:14
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00982987
Message ID:
00983014
Views:
14
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
Map
View

Click here to load this message in the networking platform