Hi all, I have a question about SQLite "attach" SQL statement. I have two database files one is a.db and the other is b.db. I want to attach b.db to a.db. I use the following commands in SQLite console mode: 1. sqlite a.db 2. sqlite> attach 'b.db' as a;
The result is b.db can be attached to a.db successfully. But there is an error occurred when I use " attach 'b.db' as a " on sqlite_compile() in C/C++ language after open "a.db" using sqlite_open() successfully, the error message is "SQL logicial error or missing database". Any wrong usage or sequence of this attach statement ? Best regards, Kei
