Hi list: Supposing a dBase without constraints (some like this but not limited to it):
CREATE TABLE tbl (Id INTEGER PRIMARY KEY, Nm INTEGER, Cl INTEGER, Dc REAL, Dm REAL, St INTEGER); A query to poblate: "INSERT INTO tbl (id,nm,cl,dc,dm,st) VALUES (?,?,?,?,?,?)" Then six binds (i = 0 to 5): sqlite3_bind_xxx (pStmt, i, ...); and a "step": resp = sqlite3_step(pStmt);. Then, if resp == SQLITE_MISMATCH (Data type mismatch) Do is there some way to know the index (i) of the offending bind? By the way: I'm trying to make a general function to import (duplicate) data from an attached table. Thanks in advance. A.J.Millan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
