Subject Database trigger and connect to database
Author
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

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?