Re: ODP: [firebird-support] Before Insert or After Insert trigger?

2018-09-06 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
Hi, Il 06/09/2018 10.41, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] ha scritto: If you need to update same table then „before” update trigger is the best choice. >>Updating another table from a Before trigger is made in a transaction >>that rolling back if exception o

ODP: [firebird-support] Before Insert or After Insert trigger?

2018-09-06 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
If you do not run it in different transaction context - like IN AUTONOMOUS TRANSACTION - then yes regards, Karol Bieniaszewski Od: Luigi Siciliano luigi...@tiscalinet.it [firebird-support] Wysłano: czwartek, 6 września 2018 08:53 Do: firebird-support@yahoogroups.com Temat: [firebird-support

[firebird-support] Before Insert or After Insert trigger?

2018-09-05 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
Hallo,   I have an After Insert/Update trigger for a table to update another table like this:   if (NEW.AGGIORNA_CONDIZIONI = 1) then     begin   update     ARTICOLI_CONDIZIONI_CLIENTI ACC   SET           end   else if ... Now I need to set a fields in the same table