Re: [firebird-support] Re: Triggers on table MON$ATTACHMENTS

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

13.07.2016 15:39, 'Ismael L. Donis Garcia' sli...@citricos.co.cu 
[firebird-support] wrote:
> Unexpected end of command - line 6, column 35

   If you execute this in isql, RTFM Language Reference for "SET TERM" command.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Triggers on table MON$ATTACHMENTS

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

>- Original Message - 
>From: hv...@users.sourceforge.net [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 |

Re: [firebird-support] Re: Triggers on table MON$ATTACHMENTS (Solved)

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

>- Original Message - 
>From: hv...@users.sourceforge.net [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

SET TERM ^ ;
CREATE TRIGGER CONNECT_TR ACTIVE
ON CONNECT POSITION 0
AS
BEGIN
  /* Trigger para validar usuarios activos del sistema */
  delete from sccon where conec not in (select a.MON$ATTACHMENT_ID from 
MON$ATTACHMENTS a);
END^
SET TERM ; ^

Best Regards

| ISMAEL |

[firebird-support] Re: Triggers on table MON$ATTACHMENTS

[hv...@users.sourceforge.net [firebird-support]]

> ---In firebird-support@yahoogroups.com,  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
 
http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-trgr.html#fblangref25-ddl-trgr-dbtrigger