>----- Original Message ----- >From: [email protected] [firebird-support] >To: [email protected] >Sent: Tuesday, July 12, 2016 3:40 PM >Subject: [firebird-support] Re: Triggers on table MON$ATTACHMENTS > >> ---In [email protected], <slibre@...> wrote : >> >> I can create triggers in the MON$ATTACHMENTS table? > > No > >> I use Firebird 2.5.6 with flamerobin >> >> I want to do something like "After Delete" >> delete from table1 where con = old.MON$ATTACHMENT_ID > > RTFM: Database triggers > >http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl->trgr.html#fblangref25-ddl-trgr-dbtrigger
CREATE TRIGGER DISCONNECT_TR ACTIVE ON DISCONNECT POSITION 0 AS BEGIN /* Trigger para validar usuarios activos del sistema */ delete from table1 where con = CURRENT_CONNECTION; END Message: isc_dsql_prepare failed SQL Message : -104 Invalid token Engine Code : 335544569 Engine Message : Dynamic SQL Error SQL error code = -104 Unexpected end of command - line 6, column 35 Best Regards ======== | ISMAEL | ========
