Re: [sqlite] Re: sqlite3_total_changes() and multiple connections

[Brownie]

It would be nice if sqlite stored a change count in the database that was 
easily accessible.

CREATE TABLE counter_table(n INTEGER);
INSERT INTO counter_table VALUES(0);

CREATE TRIGGER counter_trigger_insert
AFTER INSERT ON yourtable
FOR EACH ROW BEGIN
UPDATE counter_table SET n = n + 1;
END;

CREATE TRIGGER counter_trigger_update
AFTER UPDATE ON yourtable
FOR EACH ROW BEGIN
UPDATE counter_table SET n = n + 1;
END;

CREATE TRIGGER counter_trigger_delete
AFTER DELETE ON yourtable
FOR EACH ROW BEGIN
UPDATE counter_table SET n = n + 1;
END;

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------