I try to get a result of a query similar to
select * from table1 where table1 match 'abc -def'
This should return all rows with the value abc and not def in one of its columns. It works in sqlite browser. But not in LiveCode. It ignores the - part. Also tried NOT.
Same with the or operator. It just removes it or something?... Bad behavior.
Also when using a :1 in the match query it only returns the 1 result.
Any ideas?
sqlite match fts does not work correctly in LC?
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: sqlite match fts does not work correctly in LC?
well, that happens to be the case if i enter it like ':1' int the query. If I just use :1 without quotes that works.Also when using a :1 in the match query it only returns the 1 result.
Still... livecode seems to rip of the other operators.? Maybe buildin safety, but in this case one needs it in order for sqlite powerful match functionality to work...
https://www.sqlite.org/fts3.html