Re: using sequences in triggers to generate identities

> For application development I prefer to do it by hand and use a select
> to provide a confirmation message to the user. For batch inserts, I'll
> do a trigger.

Personally, I'd handle this logic in a trigger, even in the application. If you code this in the app (instead of in a trigger), then you'll have to remember to code it everywhere in the app. Whereas if you code this in the trigger, then it will be coded for everyone, no matter which app they use.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com