if you declare foreign key you must have exclusive accsess, i mean that no one or no other application that running with same database. and you must in SYSDBA / owner mode

regards

Tanno Vorenkamp <tvorenkamp@...> wrote:
Hi All

With FB 1.52 RC3 I tried to place a Foreign Key

ALTER TABLE APK ADD CONSTRAINT F_APK_GROUPID
FOREIGN KEY (GROUPID) REFERENCES APKGROUP
(APKGROUPID)

But at commit it gives

ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
object APKGROUP is in use

This happens even after shutdown, gbak backup and restore, reboot

Does anyone know a solution ?

regards
Tanno

Yahoo! Groups Sponsor
Get unlimited calls to

U.S./Canada


---------------------------------
Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.





---------------------------------
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.

[Non-text portions of this message have been removed]