I didn't test it from command tool yet. 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. ________________________________ From: Kees Nuyt <k.n...@zonnet.nl> To: sqlite-users@sqlite.org Sent: Monday, April 13, 2009 3:22:58 PM Subject: Re: [sqlite] fail to drop table in transaction On Sun, 12 Apr 2009 20:46:40 -0700 (PDT), Wenton Thomas <thomas.wen...@yahoo.com> wrote: >I created two tables A and B. >There exists a record which contains B's information. > >Now I need to drop table B and delete all its information in table A. >The two actions were wrapped in a transaction,but dropping table always >fail. >Error no is >SQLITE_CANTOPEN which means"Unable to open the database file". >The sqlite version is 3.5.9. > >Could anyone help me? It's hard to tell from your description what you are doing exactly. Does the same SQL work correctly from the command line tool? It is not very common to drop a table when data changes, usually the schema is stable and rows are inserted into and deleted from tables, or column values changed. It might indicate a flaw in your database schema design. -- ( 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