> On 12 Aug 2019, at 07:53, Hick Gunter <h...@scigames.at> wrote: > > You did not state your argc and argv[0] values,
Apologies, it is a 2 column table. Full details are: - argc is 4 - argv[0] is the value of the primary key for the row I want to update. - argv[1] is SQLITE_NULL, but as described, sqlite3_value_nochange(argv[1]) returns true - argv[2] is the same as argv[1] (null, but sqlite3_value_nochange returns true) - argv[3] is the new value of the non-primary key column. > so looking at the documentation would suggest that SQLite is actually asking > for an INSERT into a WITHOUT ROWID virtual table. I see that is what the documentation leads you to believe, but I can assure you I am exciting an update of the form update t set notprimarykey='some value' where primarykey='other value' Removing the sqlite3_vtab_nochange from the xColumn call gets the documented behaviour. If I keep the sqlite3_vtab_nochange and change my code in xUpdate as described in the last email, everything seems to work. I just want to check it is correct. Thanks, Kev _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
