Hi, I am working on windows application and in that i am using sqlite as the database. In that i am using multiple threads concept when i try to access the db it shows database is locked. can you please help me on this issue.
I had seen in the sqlite site that for using multithread we need to set the "THREADSAFE" value to 2. How i can set that value. please help me on this issue as soon as possible. On Sat, Sep 21, 2013 at 4:54 PM, Yuriy Kaminskiy <yum...@gmail.com> wrote: > Bernhard Amann wrote: > >> INSERT INTO <newtable> SELECT * FROM <oldtable>; > >> > >> However, this only works if <newtable> already exists, which is > actually quite cumbersome.. > >> Is there a way to make the new table 'on the fly"? > > > > create table newtable as select * from oldtable; > > ... however, this won't keep constraints, indexes, collation, comments, > and will > replace types with "generic" INT/TEXT/NUM/"": > > sqlite> CREATE TABLE t (a integer primary key /*foo*/, b text collate > nocase > unique, c datetime check (c<>''), d blob); > sqlite> CREATE TABLE u AS SELECT * FROM t; > sqlite> .schema > CREATE TABLE t (a integer primary key /*foo*/, b text collate nocase > unique, c > datetime check (c<>''), d blob); > CREATE TABLE u(a INT,b TEXT,c NUM,d); > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
