Mike,
It has nothing to do with a temporary table! That is a typical -ERROR- message when table is locked with DECLARE cursor CURSOR FOR SELECT command ... Check your code and make sure to use DROP CURSOR cursor command at the end. The DROP CURSOR command removes a cursor definition from memory, therefore freeing memory. Cursors are dropped when you use the CONNECT command to open another database, or the DISCONNECT command to close the database. Have Fun! Very Best Regards, Razzak. At 10:14 PM 10/22/2001 +0000, Mike Sinclair wrote: >... I get the follwing evil error message.... >-ERROR- This operation cannot be performed because >table MEDLIST4 is in use.(2931) > >To get rid of it, I have to disconnect and reconnect >the database. Is this normal? Why can't I drop a >temporary table in single user mode???? ===================================-============================ R:BASE Developers's Conference: http://www.rbase.com/conference Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase2000.com/events R:DCC Members: http://www.rbase2000.com/rdcc ================================================================ R:BASE, Oterro & R:Tango are registered trademarks of RBTI. ==================================-=============================
