Subject Re: [firebird-support] Set generator values in Stored Procedure
Author Martijn Tonies
Hi Tim,

> I have a stored procedure that I use to empty out tables and set up an
> empty Database.
> Is there any way of setting generator values (to 0) in a stored procedure?

Well, not via SET GENERATOR.

> Dropping and recreating the DB every time I want to reset it is a REAL
> in the neck ...
> And so is dropping and recreating the generators, tables, and associated
> triggers.

If you're using Firebird 1.5, use the EXECUTE STATEMENT statement.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions