Subject Re: Version Control of Stored Procedures/Triggers
Author robertgilland
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.