Re: [ADMIN] Trigger AFTER UPDATE OR INSERT

2007-10-21 Thread Scott Marlowe
On 10/20/07, yogesh <[EMAIL PROTECTED]> wrote: > On Oct 19, 11:05 pm, [EMAIL PROTECTED] ("Scott Marlowe") wrote: > > Yes, it's right. Triggers are part of a transaction (or run their > > own) so if the trigger fails, so does the transaction. > > > > If you really need to have something insert rath

Re: [ADMIN] Trigger AFTER UPDATE OR INSERT

2007-10-21 Thread yogesh
On Oct 19, 11:05 pm, [EMAIL PROTECTED] ("Scott Marlowe") wrote: > On 10/19/07, yogesh <[EMAIL PROTECTED]> wrote: > > > Hello frnds, > > I have a trigger on a table with After UPDATE OR INSERT ..that insert > > a record in an another table..If the Trigger Fire Correctly > > the row is inser

Re: [ADMIN] Trigger AFTER UPDATE OR INSERT

2007-10-19 Thread Scott Marlowe
On 10/19/07, yogesh <[EMAIL PROTECTED]> wrote: > Hello frnds, > I have a trigger on a table with After UPDATE OR INSERT ..that insert > a record in an another table..If the Trigger Fire Correctly > the row is inserted or updated in the database as the case is. But if > it is not fire corre

[ADMIN] Trigger AFTER UPDATE OR INSERT

2007-10-19 Thread yogesh
Hello frnds, I have a trigger on a table with After UPDATE OR INSERT ..that insert a record in an another table..If the Trigger Fire Correctly the row is inserted or updated in the database as the case is. But if it is not fire correctly then the table is also not updated on which the trig