Subject | Database trigger and connect to database |
---|---|
Author | |
Post date | 2016-07-20T09:17:46Z |
Hi
I use Delphi 2010.
I have IBObjects version 4.9.9.
I have created this database trigger on a Firebird 2.5 database:
RECREATE TRIGGER USER_TRANS_START
ACTIVE ON TRANSACTION START POSITION 10
AS
begin
begin
Insert Into User_Trans (Bruger, Hvad) Values (User,'Start Trans');
end
I use Delphi 2010.
I have IBObjects version 4.9.9.
I have created this database trigger on a Firebird 2.5 database:
RECREATE TRIGGER USER_TRANS_START
ACTIVE ON TRANSACTION START POSITION 10
AS
begin
begin
Insert Into User_Trans (Bruger, Hvad) Values (User,'Start Trans');
end
end
I have made 2 programs. One uses IBOjects. The other uses TIB.
The one using IBObjects throws this error on connect:
ISC ERROR CODE:335544361
ISC ERROR MESSAGE:
attempted update during read-only transaction
At trigger 'USER_TRANS_START' line: 12, col: 5
Removing the database trigger and the problems goes away.
CAn I avoid this?