Subject | no firing event using firebird 1.5 RC5 on w2k and XP |
---|---|
Author | cwkuok |
Post date | 2003-09-05T07:11:08Z |
I cant have any firing event on my application using firebird 1.5 RC5
and FIbplus component 4.8.1....
on both XP with with service pack 1 and W2k with service pack 3.
why?
following are the description on what I did:
on the firebird the trigger i used:
SET TERM !!;
CREATE TRIGGER POST_NEW_ORDER FOR INVOICEDETAIL ACTIVE AFTER INSERT
POSITION 0 AS
BEGIN
POST_EVENT 'new_invoice';
END!!
SET TERM ;!!
the component i used:
pFIBDatabase1, pFIBTransaction1, pFIBQuery1, SIBfibEventAlerter1.
pFIBDatabase1 dbname i used:
127.0.0.1:C:\Temp\Invoice.gdb
pFIBDatabase1 dbparams i used:
lc_ctype=WIN1251
user_name=sysdba
password=masterkey
the onAlertEvent for SIBfibEventAlerter1
procedure TDataModule2.SIBfibEventAlerter1EventAlert(Sender: TObject;
EventName: String; EventCount: Integer);
begin
if EventName='POST_NEW_ORDER' then
showmessage('Register new in the database ')
end;
The steps that I involved:
1. add event
2. register the event
3. add a record into the table
but no message showing on event alert ...
any stuff i am missing here ??
TIA
and FIbplus component 4.8.1....
on both XP with with service pack 1 and W2k with service pack 3.
why?
following are the description on what I did:
on the firebird the trigger i used:
SET TERM !!;
CREATE TRIGGER POST_NEW_ORDER FOR INVOICEDETAIL ACTIVE AFTER INSERT
POSITION 0 AS
BEGIN
POST_EVENT 'new_invoice';
END!!
SET TERM ;!!
the component i used:
pFIBDatabase1, pFIBTransaction1, pFIBQuery1, SIBfibEventAlerter1.
pFIBDatabase1 dbname i used:
127.0.0.1:C:\Temp\Invoice.gdb
pFIBDatabase1 dbparams i used:
lc_ctype=WIN1251
user_name=sysdba
password=masterkey
the onAlertEvent for SIBfibEventAlerter1
procedure TDataModule2.SIBfibEventAlerter1EventAlert(Sender: TObject;
EventName: String; EventCount: Integer);
begin
if EventName='POST_NEW_ORDER' then
showmessage('Register new in the database ')
end;
The steps that I involved:
1. add event
2. register the event
3. add a record into the table
but no message showing on event alert ...
any stuff i am missing here ??
TIA