Helen,

When I open IBAccess or IBConsole, I didn't open any database objects. I go
directly to script editor. but still it said that object is in use.
I tried this on Firebird Workbench also, but still can't do it even tough i
didn't open any database objects at all.


Best Regards,
Regina Phandu

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, November 12, 2002 6:37 PM
Subject: Re: [ib-support] can't create foreign key constraints


> At 08:48 AM 13-11-02 -0800, you wrote:
> >Hi all,
> >
> >I can't create foreign key constraints on a table. The error said that
the
> >object is in use. But no one use the db. I am sure about it. We're still
on
> >the development stage.
> >I'm using IBAccess and IBConsole, but still can't do that.
>
> If you are using IBAccess etc. then someone *is* in the database: you. If
> you can, close all inquiries on database objects and complete all
> transactions...then try your DDL statement in clear water.
>
> I don't know whether IBAccess and IBConsole are capable of closing
> everything down (not saying they can't, just don't know if they can...)
If
> you need a tool that can do this, grab IB_SQL from
> www.ibobjects.com. Don't open the browser; and before you run your DSQL
> or script, go to the Transaction page and commit any transactions pending
> there, by clicking on the folder-like icon with the tickmark on it.
>
> heLen
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>