System.Data.SQLite

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