Re: Table cannot be dropped (314)

} > From: targon!herman (Herman Nienhuis) } We have written a software installation tool using ESQL/C. This } software uses a table to control the process of altering some } of the existing tables. At the end of the installation this table } has to be dropped. At that moment the installation tool is the } ONLY database user, without any running transactions. } } When we try to drop the table we get DB error 314 "table in use", } ISAM error 0. How can the table be in use if there are no other } users? } } We are running Informix Online 5.0, the database is in ANSI MODE. } } Any help would be appreciated. } I've has this problem before; make sure you have closed all cursors that reference the table you are trying to drop. **-------------------------+---------------------------** |James Bennett | Phone: 916.891.5281 | |Bi-Tech Software, Inc | Fax : 916.891.5011 | |1072 Marauder, Suite A | EMail: james@bi-tech.com | |Chico, CA 95926 | #include <disclaimer.h> | | | #include <smartquote.h> | **-------------------------+---------------------------**