General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
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