Re: Dropping temp tables--a revelation and a weak error message

[MikeB]

I don't think "temporary" has anything to do with it.  Think about it.  Dropping a table with a cursor open. ----- Original Message ----- From: mjs To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 01, 2002 8:57 AM Subject: Dropping temp tables--a revelation and a weak error message I hope this saves somebody some time.  Did you know, that when you create a temporary table, if you create a cursor for that table, you have to drop the cursor before you can drop the table.  If you try to drop the table without dropping the cursor, you get a somewhat misleading error messags...something about "Resources are not available".   This may be obvious, but it can be a real problem that's hard to find.  If your app creates a cursor, and then for some reason (like the app has a bug and you never get to the part where you drop the cursor) you try to drop the table and recreate it, expecting it to have no rows of data, it won't drop, the recreate will be ignored, and you will still have old data in the table where you thought you had no data!   Hope this helps somebody!   Mike