Subject | Re: Version Control of Stored Procedures/Triggers |
---|---|
Author | robertgilland |
Post date | 2007-05-14T04:37:21Z |
What I am looking for is a way to look at a stored procedure and
determine its version.
I cannot do a string comparison, because IB/FB reformats the stored
procedure after you call CREATE PROCEDURE
What would be good would be a tag like:
CREATE PROCEDURE PROC1
VERSION_TAG 1
BEGIN
END;
then I can do this:
SELECT *
FROM RDB$PROCEDURES
WHERE ( VERSION_TAG < 2 )
Kind Regards
Robert.
determine its version.
I cannot do a string comparison, because IB/FB reformats the stored
procedure after you call CREATE PROCEDURE
What would be good would be a tag like:
CREATE PROCEDURE PROC1
VERSION_TAG 1
BEGIN
END;
then I can do this:
SELECT *
FROM RDB$PROCEDURES
WHERE ( VERSION_TAG < 2 )
Kind Regards
Robert.