Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving the signature of a stored procedure
Message
From
02/02/2005 09:16:25
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00982987
Message ID:
00983026
Views:
21
>You can just open the DBC as a table [USE MyDBC.dbc ALIAS DBCTable] and read the contents of the source code memo field just like any other field in a table. Then you can write code to parse through it looking for whatever information you want to write in your metadata tables.

>SELECT ... FROM MyDBC.DBC DBCTable WHERE ...

>also works.

Unfortunately, the code for the AfterAppendProc event will appear in the stored procedures. Within the execution of that procedure, I can't close the database to reopen it as table. That is why I was hoping to have some DBGETPROP for this.

I understand that I could do my parsing offline, once from time to time, but that is unreliable. Automatic updating would be much better.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform