Try DISCONNECT and re CONNECT Bill Cook Kent WA USA ----- Original Message ----- From: "Dan Goldberg" <[EMAIL PROTECTED]> To: "Rbase-L" <[EMAIL PROTECTED]> Sent: Tuesday, November 20, 2001 10:57 AM Subject: Problem creating and dropping tables
> I have a command that creates a temporary table. > > drop table costtemp nocheck > create temporary table costtemp (serial int) > > First it drops the table in case something happened. > > It works sometimes and doesn't other times. It gives me the multi-user error > message > > "Resources required by command are not available" with the "retry" and > "cancel" buttons. > > Then gives me the error > > "Unavailable resource encountered during DROP command(2440)." > > What is unusual is if I turn off the "error messages" setting it will most > of the time work. But if I turn on the "error messages" it will never work. > > Since it is a temporary table it shouldn't be concerned with multi-user > issues. > > Anybody have ideas?? > > I am using window version 6.5+ 1839XRT03 > > > Dan Goldberg > >
