I did set up a trigger for DELETEs, but even then the fts_table would find a
way to have more rows than master after a short while. Some delete's are
simply being ignored/failed by the FTS module it seems.
I would have liked to also use triggers for INSERTs, but how do you create a
trigger when the data to be inserted on the trigger is not part of the 'NEW'
reference?
-PQ
----- Original Message -----
From: "Michael Ruck" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Saturday, April 07, 2007 8:35 AM
Subject: AW: [sqlite] Master table with child FTS table
How about managing fts_table using triggers attached to the master table?
That should take care of synchronization issues IMHO.
Mike
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
