Is there some depending object ?
-----Mensaje original-----
De: Stephen Boyd [mailto:sboydlns@...]
Enviado el: martes, 16 de noviembre de 2004 20:30
Para: firebird-support@yahoogroups.com
Asunto: [firebird-support] table is in use error



I have a script that I use to upgrade a database to a new release
level. Although in this instance I am using it to create a brand new
database. In that script I have the following:

drop table table1;

commit;

create table table1 (
somefield integer;
);

commit;

This gives me a 'table is in use error'. Since I am creating a new
database and am the only person logged in to the database the table
clearly cannot be in use. I put in the commit after the drop table
command to make sure that the current transaction was closed so that
the table wouldn't 'open' under an old transaction. So what can be
causing the problem?

I am using using isql under Firebird 1.0.3 to run the script.






Yahoo! Groups Sponsor

Get unlimited calls to

U.S./Canada




----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004


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