On 31.08.2007 10:45 CE(S)T, Yves Goergen wrote:
> 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...
When I do that from an SQLite console, it works as expected. So I'll
head over to
On 31.08.2007 06:03 CE(S)T, Dan Kennedy wrote:
> On Fri, 2007-08-31 at 00:09 +0200, Yves Goergen wrote:
>> CREATE TEMPORARY TABLE attached_db.temp_table
>
> I'm not sure where that table is created - in the temporary
> namespace or as part of attached_db. Checking...
>
> SQLite version 3.4
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
On 31.08.2007 00:23 CE(S)T, RaghavendraK 70574 wrote:
> Pls see if u hv an open sqlite3 terminal.sometimes this can also
> cause a prob with begin tx and just kept it open.
Really, I don't. Trust me. :)
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unc
On Fri, 2007-08-31 at 00:09 +0200, Yves Goergen wrote:
> 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;
>
> Erro
ROTECTED]>
Date: Friday, August 31, 2007 3:41 am
Subject: Re: [sqlite] Table locked - why?
> On 30.08.2007 23:00 CE(S)T, [EMAIL PROTECTED] wrote:
> > Probably another thread or process is reading from the database
> > and does not want you to drop the table out from under it.
>
>
2007 3:41 am
Subject: Re: [sqlite] Table locked - why?
> On 30.08.2007 23:00 CE(S)T, [EMAIL PROTECTED] wrote:
> > Probably another thread or process is reading from the database
> > and does not want you to drop the table out from under it.
>
> Surely not. This databa
On 30.08.2007 23:00 CE(S)T, [EMAIL PROTECTED] wrote:
> Probably another thread or process is reading from the database
> and does not want you to drop the table out from under it.
Surely not. This database is there for testing and development purposes
only and my application is the only one that o
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 a
Yves Goergen <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I want to modify the structure of a table, particularly remove a column.
> Since SQLite won't help me with that, I'll need to go the hard way by
> copying all data to a temp table, then re-creating the table with the
> new structure and copying all
BEGIN TRANSACTION;
CREATE TEMPORARY TABLE attached_db.temp_table (...);
INSERT INTO attached_db.temp_table SELECT * FROM attached_db.table1;
/* Add a comit */
COMMIT;
DROP TABLE attached_db.table1; -- Error: Table is locked
Yves Goergen <[EMAIL PROTECTED]> wrote: Hi,
I want to modify the st
11 matches
Mail list logo