Greetings!
I have this update:
BEGIN;
INSERT OR REPLACE INTO A
SELECT * FROM client.A WHERE id = 1 AND Date != '2014-06-22';
INSERT OR REPLACE INTO A
SELECT * FROM client.A WHERE id = 2 AND Date != '2014-06-22';
...
...
INSERT OR REPLACE INTO A
SELECT * FROM client.A WHERE id = 19 AND Date != '2014-06-22';
INSERT OR REPLACE INTO A
SELECT * FROM client.A WHERE id = 20 AND Date != '2014-06-22';
END;
Is there a way to keep a count of the INSERTS/REPLACES that took place
between the BEGIN and END? I was looking into the SQL changes() function,
http://www.sqlite.org/lang_corefunc.html#changes
but wouldn't it have to be done after each INSERT?
thanks.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
