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

2018-09-06 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

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

2018-09-06 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Hi, >> Now I need to set a fields in the same table like this to track the >>updates performed: If you need to update same table then „before” update trigger is the best choice. If you use after and run there UPDATE command you must take into accout recursive call. Your update command run

Re: [firebird-support] Sequential auto incremental numbering

2018-09-06 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Wed, Sep 5, 2018 at 10:07 AM, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > 2018. 09. 02. 17:03 keltezéssel, 'Christian Giesen' ch...@xt.co.za > [firebird-support] írta: > > > > > I have a need to generate unique sequential invoice/credit note numbers.. > > I fully understand the

[firebird-support] Question on UDF's

2018-09-06 Thread Robert Tulloch tult...@hughes.net [firebird-support]
Hi: Any insight appreciated. Installed FB 2.5 on win 10. Using IB_SQL.exe for access. GDB is from an old IB 6.02 which works flawlessly on XP I have several of my UDF libs in udf dir When I open w IB_SQL. exe and look at UDF's all I get showing are 6 from ib_sql and shows error "Unexpected