--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...>
wrote:

>
> >>> 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.

I use a DB with no Database trigges.
I create a table.
I create a database trigger as INACTIVE.
I disconnect.
I cant connect anymore using IBO.


Whether or not the INACTIVE part is visible to others - I dont know.
Whether IBO then starts a read-only transaction somewhere - I dont
know. But when the trigger is INACTIVE it should not have any
influence. Should it?

>
>
> --
> 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/
>