I have a requirement in which I need a list of all contacts that are edited / modified.
According to the documentation for Android,
_SYNC_DIRTY
will be set every time the contact is edited. But this seems to have an error that makes it always equal to 1 (no matter what), even we explicitly set it to 0.
So, I was wondering if I can create SQLite TRIGGER in the contacts database. Thus, every time a contact is edited, the edited contact identifier is populated into another table, which I can read later from my application.
I tried this ...
CREATE TRIGGER IF NOT EXISTS updated_contacts UPDATE ON 'contacts.db'.phones
BEGIN
INSERT INTO updated_table SET updated_id=old.person;
END;
But here are a few problems ...
1) "" - . ( , "contacts.db" ).
2) updated_table - mydatabase.db, . , TRIGGERS .
Android 1.6
, Android.
.
.
.