What IBAdmin Tool do you use?
Most good ones (I thought) have a very good version control system.
IBExpert keeps an entire history of each and every change you make and you
can compare current with any previous version with highlightted differences
You can even compare the current DB version with any other DB procedure.
Alan

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]On Behalf Of robertgilland
> Sent: Monday, 14 May 2007 2:37 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Version Control of Stored
> Procedures/Triggers
>
>
> 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.
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>