[sqlite] Problem with MATCH query

[Gavin]

Hi

I am using FTS3 for table Positions_Text. However I am getting an 
error 'unable to use function MATCH in the requested context' when
using:

SELECT DISTINCT [Positions].[PosID] FROM [Categories], [Positions] JOIN 
[Positions_Text] ON [Positions].[PosID] = [Positions_Text].[rowid] WHERE 
[Description] MATCH 'test' AND [Categories].[PosID] =
[Positions].[PosID] AND 
[Categories].[CatID] = '1'

If I use 

SELECT DISTINCT [Positions].[PosID] FROM [Categories], [Positions] JOIN 
[Positions_Text] ON [Positions].[PosID] = [Positions_Text].[rowid] WHERE 
[Description] MATCH 'test' AND [Categories].[CatID] = '1'

removing section: AND [Categories].[PosID] = [Positions].[PosID] 

the query works. Anyone know what the problem is?

Thanks

Gavin 

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