At 12:08 29.04.2003 +0200, you wrote:

>However, I do have an instance in one of my applications where there is a
>master - detail relationship between two tables. I need each "set" of
>detail records to have numbering starting at 0. I would like to use a
>generator to do it - at the moment, it's done in code.

You haven't asked the question yet, but I assume this could be a case where
you soon will want sequential numbering. If so, take a look at "An
Auditable Series of Numbers", which you can download from
http://www.ibobjects.com/TechInfo.html.

As for your original question, setting a generator to a value is something
you ought to do in a script, not a stored procedure or trigger.

By the way, Firebird is a great database that we jokingly called a "Sports
tank" in some of these newsgroups some time ago. I'm impressed by how you
try to twist this "sports tank" so that it can be used as a tractor to
plough the fields. It works a lot better once you try to use it as intended
(work with Firebird, not against it). ;o)

HTH,
Set