Thank you so much, you guys saved my life.





--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

> At 05:19 PM 11/17/2004, Bill Meaney wrote:
>
> >You do not need to empty the table before you drop it.
> >
> >Make sure no other process is connected and just drop the table.
>
> Bill's right. You're seeing this error because ISQL has
> established an interest in the table when it deleted all
> the records. As long as there is a connection with an interest,
> you can't drop the table. So, in fact, you don't even need
> to check that no one else is using the table - you'll get an
> error if anybody has an interest.
>
> Regards,
>
>
> Ann