I can't post the code.. but I figured it out why there is an infinite loop..
I placed the another insert statement that cause trigger again..
I guess i can't use insert in trigger?
SKurosky <skurosky_at_aol.com> wrote in message
news:20000203140400.27125.00001253_at_ng-ca1.aol.com...
> >ELEE WROTE
>
> >I created the sequence for auto num gen
> >then created trigger for that before insert..
> >now, it goes into the infinite loop..
> >any suggestion for stoping infinite loop?
>
> Post your code please
>
Received on Sat Feb 05 2000 - 23:41:14 CST
