Terry wrote:

> I have a production Firebird 1.5 database that has been serving me
> very well for a few years now. I'm adding some new stuff to it.
>
> I added some fields to the main table, called COMPLAINTS, then created
> a new table called TI_LOCATIONS. After creating and populating this
> table, I added another field to COMPLAINTS to reference TI_LOCATIONS,
> called TI_LOC_ID.
>
> When I try to add a contraint to COMPLAINTS, making TI_LOC_ID a
> foreign key to TI_LOCATIONS, I receive an "object TI_LOCATIONS is in
> use" error.
>
> I have closed everything in IB_Expert that had anything to do with
> this new table, and the client application is absolutely not even
> aware that it exists yet. How can it be "in use"? This is driving me
> nuts!
>
> Thanks for any help.
>
> -Terry
>

Close ALL client connections.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br