On Apr 1, 2010, at 2:39 PM, Radovan Antloga wrote: > I did not find any info about my situation in page > http://www.sqlite.org/lockingv3.html > > I would just like a confirmation if this is expected > behaviour. > > I have locking mode = normal. Steps are: > > 1. open database > 2. open statement (simple select from T1) > and doing 1 step > 3. execute statement (drop table T2) > > I get SQLite error 6 database table is locked. > > So while statements are in progress it is not possible > to drop any tables.
That is correct. It is not possible to do a DROP TABLE if the database handle has any active statements (apart from the "DROP TABLE" statement itself of course). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
