Subject How can I skip an Insert ?
Author yazbeckmona

I would like to add something to my trigger "BeforeInsert" that would
ignore every line that is already in the database. How could I do
that, I have absolutely no idea, I never worked with trigger before! I
need to NOT insert lines that is already in the database (of course,
because now I have some primary key duplicate error). (And I don't
want to change my SQL query, because I tried already everything and it
is terribly long.)

Here's my trigger with a key generator:
if (NEW.idemployeur IS null) then
NEW.idEmployeur = GEN_ID(G_EmployeuridEmployeurGen7, 1);

Thank you so much for any help!