2008/9/16 Aravinda babu <[EMAIL PROTECTED]>: > Hi all, > . . . > static const char *updateCmd = "UPDATE cert_store_table set lastRowFlag = > :lastRowFlag where lastRowFlag = :lastRowFlag;" ; > ---- <---- same named parameter twice > . . . > Is there any wrong in the above code ? > > > If i update on the command line using the command , it is working.What is > the issue ?????????????????????? > . . . > > Waiting for your reply, > > Aravind.
Hi Aravind, You are using the same parameter name - only the first bind value will be used. See http://www.sqlite.org/c3ref/bind_blob.html. I suspect that you are ignoring an error from your second call to sqlite3_bind_int. Rgds, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
