Michael

 

Check the properties of the IB_Transaction component that is set as default for IB_Connection component.

Apparently IB_Transaction used for connection is 'read-only'. You could set IB_Connection.DefaultTransaction to some 'read-write' if it is blank...

 

HTH

Marcin

 

------ Wiadomość oryginalna ------

Od: "Michael.Vilhelmsen@... [IBObjects]" <IBObjects@yahoogroups.com>

Do: IBObjects@yahoogroups.com

Wysłano: 20.07.2016 11:17:46

Temat: [IBO] Database trigger and connect to database

 

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.

< span>

CAn I avoid this?