contact [EMAIL PROTECTED]
-Original Message-
From: Paul Quinn [mailto:[EMAIL PROTECTED]
Sent: Monday, April 09, 2007 12:39 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Master table with child FTS table
I've worked this issue with FTS1 and FTS2 and they both have the same
problem
.
-PQ
- Original Message -
From: "Samuel R. Neff" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, April 09, 2007 6:01 AM
Subject: RE: [sqlite] Master table with child FTS table
Might I suggest trying the exact same scenario with FTS1 instead
: [sqlite] Master table with child FTS table
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
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
] Master table with child FTS table
I have a database setup that creates a master table, and a child 'Full Text
Search' (FTS) table that matches it by rowid. My problem is with keeping the
FTS table in sync with the master. Let me explain in SQL:
setup like so:
CREATE TABLE master (a, b);
CREATE
5 matches
Mail list logo