Hi Mike,

> I'm frustrated and do not understand why I cannot add a FK.
>
> Connecting to my database (Fresh) and I'm the only person logged into Firebird 1.5. I'm using DBWorkbench where I'm trying to add a FK as follows:
>
> ALTER TABLE AM_HISTORY_DETAIL ADD CONSTRAINT FK_AM_HISTORY_DETAIL_AM_HISTORY
> FOREIGN KEY (HISTORY_ID) REFERENCES AM_HISTORY(HISTORY_ID)
> ON DELETE CASCADE
> ON UPDATE NO ACTION;
>
> When I try to commit, I receive the following error:
>
> ISC ERROR CODE 335544345
>
> ISC ERROR MESSAGE
> lock conflict on no wait transaction
> unsuccessful metadata update
> object AM_HISTORY is in use
>
> How can AM_HISTORY be in use?
>
> Any ideas what I can try?

If you are really the only one connected, then you might check, if you
have set the "Use a connection per SQL/Script Editor" option in DBW in
the Firebird specific options in Preferences | DB Engine Specific | Firebird

Just in case you have several editors open. ;-)


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