Hi, You could throw an exception in the trigger, that would prevent that the row is deleted, like a constraint. But I'm not sure if this is what you want. Other than that, I guess you would have to re-insert the row.
Regards, Thomas On Fri, Jun 14, 2013 at 9:29 AM, Grant Beaty <[email protected]> wrote: > I use triggers to modify some rows as they are inserted or updated, but > sometimes I need to roll-back a DELETE. Is this possible to do within a > trigger, or do I need to use the provided connection to re-INSERT the row? > > Thanks, > Grant > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
