Subject | Re: [firebird-support] Re: Database trigger - On start transaction |
---|---|
Author | Thomas Steinmaurer |
Post date | 2008-12-18T14:00:19Z |
>>> 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
> approach.
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/