Re: No after statement trigger

[Mark Wallace]

I need to write to the *same* table, multiple times. To give a concrete example, the user requests to insert one row into the ORDERS table. The triggers need to ensure that four (or five or six, depending on the business rules that govern the specifics of the user's insert) rows are inserted into the ORDERS table, the one they requested (unchanged), plus a few more according to the business rules.