Well I'm very new to SQLite but shouldn't: UPDATE table SET Value=12.3 WHERE Address=7 and Port=1
be: UPDATE table SET Value='12.3' WHERE Address='7' and Port='1'; sqlite3_vmprintf() is the recommended method to build SQL with parameters. Saturday, March 1, 2008, 6:31:50 PM, you wrote: tti> The code is very long, I'll try to put here the core of my application. tti> I'm using a C++ Class where one function is "sqlraw" that I use to tti> execute a SQL statement: tti> CLASS DEFINITION tti> sqlite3 *db; tti> int expander:: tti> open_db(char * pDbName) tti> { tti> int rc; tti> rc = sqlite3_open(pDbName, &db); tti> if( rc ) tti> { tti> fprintf(stderr, "Can't open database: %s\n", tti> sqlite3_errmsg(db)); tti> sqlite3_close(db); tti> exit(1); tti> } tti> return(0); tti> } tti> int expander::sqlraw(char *pSql) tti> { tti> int rc; tti> char *zErrMsg = 0; tti> printf("SQLRAW: SQL=%s\n",pSql); tti> printf("Database %d\n",db); tti> rc = tti> sqlite3_exec(db,pSql, NULL, NULL, &zErrMsg ); tti> printf("SQLRAW: Stato=%d tti> - OK=%d\n",rc, SQLITE_OK); tti> if( rc!=SQLITE_OK ) tti> { tti> fprintf(stderr, tti> "SQL error: %s\n", zErrMsg); tti> sqlite3_free(zErrMsg); tti> return(-1); tti> } tti> return(0); tti> } tti> int main(int argc ,char *argv[]) tti> { tti> expander expio; tti> char sPre[2048[; tti> expio.open("test.db"); tti> strcpy(sPre,"UPDATE tti> table SET Value=12.3 WHERE Address=7 and Port=1"); tti> if (expio.sqlraw tti> (sPre) == 0) tti> { tti> / / Action for no error tti> } tti> else tti> { tti> // Manage error conditions tti> } tti> When I execute the code, sqlraw tti> function print the pSql string, and this is the same I pass. tti> The tti> Database descriptor is the same returned from open function, and status tti> code is OK!!! tti> But table value isn't updated. tti> I don't understand tti> what's matter, and because i haven't any error message I can't debug tti> it. tti> Any suggestion is VERY VERY appreciate tti> Pierluigi Bucolo -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users