Nico,

> I'm just thinking something. In the pre insert trigger I still

do

> some field validation. What if an error occurs in the trigger, or the

user

> cancels his insert, I guess that's one generator number wasted ?? Should

I

> do the checking on the client, to avoid that a record is refused by the
> server ?

If you don't want to waste a number then you have a lot more to worry about
than that. I say don't bother and spend your time elsewhere.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com