Triggers operate on the server level, transactions are started and committed upon request from the client. There's no way to commit within the trigger itself.

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of dirinler
Sent: 17. oktober 2008 10:42
To: firebird-support@yahoogroups.com
Subject: [firebird-support] trigger

Hi there;

delphi 7 fb 2.1
i used to be the IBX data components;i wantto catch the events thats
why i use ibevent component.but there is a problem i create the tigger
on the ibxpert but it doesnt aggree the commit word?can someone help me
about this?
the current trigger

AS
begin
post_event 'dbchanged';
commit;/*the error is here feature not suppoted

end


Thanks.


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links