Robert Gilland wrote:
Is there any way of storing/setting a version number of a Stored Procedure/Trigger? So we can know if a Stored Procedure/Trigger is out of date?
Lele Gaifax answers:
I use something like the following: I have one-file-per-SP containing the implementation, and the whole thing is kept under SVN.
Each source looks like:
SET TERM ^;
CREATE OR ALTER PROCEDURE some_sp_name_here AS
BEGIN
EXIT;
END ^
UPDATE rdb$procedures
SET rdb$description = '$Id$'
WHERE rdb$procedure_name = 'SOME_SP_NAME_HERE' ^
This is nice because most tools are able to show that field side-by-side with the SP name, in their browser.
FB 2.x has a cleaner syntax to say the same.