"Joanne Pham" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I used sqlite3_prepare_v2(pDb,stmt,-1,&pReadStmt,0) > for preparing the statement and used sqlite3_step(pReadStmt); to get > each row. > my stmt is : > select remoteId, bytesIn from compressTable > then it worked ok > > but if my statement has the attach database then it didn't work > because the sqlite3_prepare_v2 has problem. attach database > 'CommonDB' as CDB; select remoteId, bytesIn from compressTable where > remoteId in (select remoteId from CDB.remoteWXTable where > remoteType=1); detach database CDB;
That's three statements, not one. You need to prepare and execute each one separately. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
