Hi All, I have the following codes to execute the sql file but the error message return back that dot(.). It seems like sqlite3_exec didn't like ".output wanPerfTableTest". So how go to get arround with this command ".output wanPerfTableTest" Your help is greatly appreciated. Thanks JP
strcpy(&stmt[0],".read /tmp/dump_WAN.sql"); if (bIsConnected) { sqlSt= sqlite3_exec(pDb,stmt , NULL, 0, &errMsg); if (sqlSt != SQLITE_OK ) { ................... } } my file is defined as: attach database 'CommonDB' as CDB; .output wanPerfTableTest .mode csv select datetime('now'); select startTime, appName, appType, isAppDeleted, remoteWXId, hostName remoteWXType, active, bytesToWan, bytesFromWan from wanPerfTable JOIN CDB.appMapTable on wanPerfTable.appId = CDB.appMapTable.appId JOIN CDB.remoteWXTable on wanPerfTable.remoteId = CDB.remoteWXTable.remoteId; detach database CDB; select datetime('now'); ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users