I have run into this many times myself. It always ends up being there is a
transaction that has not been committed.

If you are viewing the data in a table through IBExpert then a transaction
has started. You can rollback or commit this transaction by clicking on the
x or the check mark at the top of the tables page. Once you are sure all
your transactions are committed you should be able to add constraints.
Logging out of the database has the same effect. Todd.



_____

From: daniel@... [mailto:daniel@...]
Sent: Tuesday, October 26, 2004 11:56 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] New constraint in ibexpert...



Hello everyone...
I'm trying to create a new contraint using IBExpert but it always return
that the object TABLE is in use. It's necessary to shutdown the
database? How can I procede?
Thanks, Daniel.






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129676qdj/M=315388.5529720.6602079.3001176/D=gr
oups/S=1705115386:HM/EXP=1098899828/A=2372354/R=0/SIG=12id813k2/*https:/www.
orchardbank.com/hcs/hcsapplication?pf=PLApply&media=EMYHNL40F21004SS> click
here



<http://us.adserver.yahoo.com/l?M=315388.5529720.6602079.3001176/D=groups/S=
:HM/A=2372354/rand=991100425>



_____

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
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



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