Re: 314 - table in use error

aleggett@na.ko.com wrote: > > I found a posting related to a problem I am having. I'm running a .4gl > script and doing a DROP. I receive the message 314 table in use. This > table is not in use - I even brought the system up in maintenance (single > user) mode to ensure this. > > I found a posting from Gennady (gena@oubaes.freenet.kiev.ua) with a great > solution. Use SQL to run the following commands: > > DELETE FROM syscolumns where tabid = > (select tabid from systables where tabname "mytable")> > DELETE FROM systables were tabname - "mytable" AAAAAAAAUUUUGGGGHHHHHH!!!!!!! DO NOT DO THIS! Did someone really recommend this??? Just goes to show you get what you paid for on these newsgroups... Assuming you are using OnLine, this will irretrievably (alright, maybe it's reversible, but it'll be ugly) corrupt your instance. All sorts of references to this table will still exist in your OnLine instance in many other places, most of which you cannot access. You are just asking for trouble if you do this. What do you mean you brought the engine up in single-user mode? And what else (if anything) does your 4GL program do? June ---- June Tong Informix Software ---- ---- Senior Consultant (650) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ----