On 30.08.2007 22:55 CE(S)T, Ken wrote: > BEGIN TRANSACTION; > CREATE TEMPORARY TABLE attached_db.temp_table (...); > INSERT INTO attached_db.temp_table SELECT * FROM attached_db.table1; > > /* Add a comit */ > COMMIT;
Error: cannot commit transaction - SQL statements in progress > DROP TABLE attached_db.table1; -- Error: Table is locked -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my web laboratory at http://beta.unclassified.de ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------