Subject Re: [firebird-support] Re: Triggers on table MON$ATTACHMENTS
Author Ismael L. Donis Garcia
>----- Original Message -----
>From: hvlad@... [firebird-support]
>To: firebird-support@yahoogroups.com
>Sent: Tuesday, July 12, 2016 3:40 PM
>Subject: [firebird-support] Re: Triggers on table MON$ATTACHMENTS
>
>> ---In firebird-support@yahoogroups.com, <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 |
========