Well,It works in command tool. Maybe there exists some error in my code.
I have to drop the table,because I will use the same table name with different table struct. Thanks for your help. ________________________________ From: Kees Nuyt <k.n...@zonnet.nl> To: sqlite-users@sqlite.org Sent: Monday, April 13, 2009 8:10:12 PM Subject: Re: [sqlite] fail to drop table in transaction On Mon, 13 Apr 2009 02:35:46 -0700 (PDT), Wenton Thomas <thomas.wen...@yahoo.com> wrote: > I didn't test it from command tool yet. Well, that is the first thing to try. > I have a table (call it table A) to record other > table's information. When I delete a table, I also > delete all its information recorded in table A. > I wonder whether it is legal to drop a table and > delete another table's records in one transaction. That shouldn't be a problem. But it is a weird construction, unless tableB is an application table, and tableA part of a dictionary. For a normal application, you wouldn't have to drop tableB, but just insert / delete rows. What are you trying to accomplish? -- ( Kees Nuyt ) c[_] _______________________________________________ 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
