Subject | RE: [firebird-support] I need some help ... |
---|---|
Author | Ann W. Harrison |
Post date | 2004-11-17T22:45:55Z |
At 05:19 PM 11/17/2004, Bill Meaney wrote:
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
>You do not need to empty the table before you drop it.Bill's right. You're seeing this error because ISQL has
>
>Make sure no other process is connected and just drop the table.
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