just to add to the above i guess "MYTRIGGER" is unique to each table?... I was hoping to insert the same trigger on every table with a script so would prob need to change this name on every trigger insert?
On Wednesday, 15 April 2015 14:36:56 UTC+1, blu10 wrote: > > thanks Noel, > > I managed to insert one trigger.... shouldn't i be able to add this > trigger to all tables now? > When i do i get the below..... sorry if these are simple questions but im > no database expert > > Trigger "MYTRIGGER" already exists; SQL statement: > <http://9.162.150.89:8082/query.do?jsessionid=477d7e8c2a2117a4bf2d111b76723d72#> > > On Wednesday, 15 April 2015 10:04:09 UTC+1, Noel Grandin wrote: >> >> You need to use the fully qualified class-name of your trigger. >> >> -- 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/d/optout.
