Subject | Procedures that operate on a given table |
---|---|
Author | Eduardo Resek |
Post date | 2006-03-06T04:07:37Z |
For component development purposes, I need to grab all procedures that
perform each of the UID operations on a given table. From the
RDB$DEPENDENCIES system table I can get the procedure names, but not what
they do. I have tried to select from RDB$PROCEDURES filtering out those
whose body (RDB$PROCEDURE_SOURCE contains 'DELETE FROM <TABLE_NAME>, etc.,
but this is obviously misleading, as there can be commented code in
procedure's text, or the words can be split across lines. Does anybody know
about a precise method for that?
Thanks in advance.
Eduardo
[Non-text portions of this message have been removed]
perform each of the UID operations on a given table. From the
RDB$DEPENDENCIES system table I can get the procedure names, but not what
they do. I have tried to select from RDB$PROCEDURES filtering out those
whose body (RDB$PROCEDURE_SOURCE contains 'DELETE FROM <TABLE_NAME>, etc.,
but this is obviously misleading, as there can be commented code in
procedure's text, or the words can be split across lines. Does anybody know
about a precise method for that?
Thanks in advance.
Eduardo
[Non-text portions of this message have been removed]