Hi all

I have a table with ID, NAME etc fields and numerous check and
foreign key constraints.
I get ID number in before update trigger from a generator.

After making structure in testing time I found following problem.

If any constraint causes an exeption user get error message but my
generator already increased.
Example: If user doesn't set NAME before clicks ok to add new record
check constraint gives a warning.
But how can I prevent my generator from increasing at this time?

Thanks in advance

Sandor Szollosi