Subject Re: [firebird-support] Re: Database trigger - On start transaction
Author Thomas Steinmaurer
>>> Then connecting using IBX I delete the database trigger and I can once
>>> 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
> approach.

Activating / deactivating a database trigger works fine here. So my
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
no error.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/