I have a virtual table implementation, and I would like to use the INSERT OR REPLACE syntax to simplify actions for the user. In my xUpdate method, for the case where insertion is occuring,
else if ( argc > 1 && SQLITE_NULL == sqlite3_value_type ( argv[0] ) ) { I do check a uniqueness constraint, and return an error SQLITE_CONSTRAINT_UNIQUE, which I presume is the right thing to do. So, my question is, is this the right thing to do to get INSERT OR REPLACE on a virtual table, or something else, or maybe that syntax is not supported on virtual tables? Thanks, -dave _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users