Re: [SQL] Trigger/Sequence headache

2006-02-12 Thread Foster, Stephen
That's what I thought was going to be the answer. I was just hoping I was making a mistake somehow. It's no big deal but I like things organized and hate giant holes. Ok, one more thing for one of the batch jobs. No problem I have a cleanup routine. Thanks for the help, Lee Foster/ -Orig

Re: [SQL] Trigger/Sequence headache

2006-02-12 Thread Stephan Szabo
On Sun, 12 Feb 2006, Foster, Stephen wrote: > This is going to be one of those stupid problems of mine. I have an > insert trigger setup to verify that duplicate or repeating information > isn't storage in the table. If trigger function finds the information > as a duplicate it returns a NULL a

[SQL] Trigger/Sequence headache

2006-02-12 Thread Foster, Stephen
This is going to be one of those stupid problems of mine.  I have an insert trigger setup to verify that duplicate or repeating information isn’t storage in the table.  If trigger function finds the information as a duplicate it returns a NULL and the information isn’t added; that works.  T