|Subject||Re: [firebird-support] Re: Database trigger - On start transaction|
>>> Then connecting using IBX I delete the database trigger and I can onceActivating / deactivating a database trigger works fine here. So my
>>> again connect via OBObjects
>>> But should I get this error sinse the database trigger is INACTIVE?
>> Perhaps the trigger already existed as ACTIVE and the RECREATE TRIGGER
>> statement didn't get committed?
> No - just tried it from scratch on a different DB using the above
guess is still, that the INACTIVE isn't visible to others and as IBO
might start a read-only transaction for query metadata, you get this
error. IBX probably does not start a read-only transaction at all, thus
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and