The function is given a collection of data that needs to be either insert or update into the database. One options would be to use INSERT OR REPLACE INTO, but the desire is not to remove N add when it is an update, but simply do an update using the rowid. All the new items that need to be inserted won't have a rowid.
Is it possible to have two different prepare statements at one time; one for insert and another for update. Then check each piece of data for a rowid to determine which approach to use. Once it is all done, clean up both prepare statement. Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
