Then perhaps an insert into a VIEW with an INSTEAD OF trigger would be appropriate?
Best regards, Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested 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. For the trigger, the data is not available in the trigger because the data that would be inserted into the FTS on the trigger is not part of the insert for the master table. Thus it is not available on the trigger. -PQ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
