On 31.08.2007 00:50 CE(S)T, Virgilio Alexandre Fornazin wrote: > Did you closed the cursor opened at 'select *...' ? > Thats probably the reason you have getting a 'table is locked' error.
I'm using the .NET wrapper to SQLite that should handle all API internals for me. Even disposing the previous SQLiteCommand object from "INSERT INTO ... SELECT * FROM ..." doesn't help here. Maybe I should retry it with a plain SQLite console and figure out whether the bug is in the .NET wrapper (just as the previous one I've found...). Stay tuned... -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my web laboratory at http://beta.unclassified.de ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------