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

pain

> 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
Server.
Upscene Productions
http://www.upscene.com