Re: [sqlite] Snippet function with Distinct query fails

2014-03-19 Thread Hick Gunter
My guess is that your windows version does not have the fts3 extension loaded/compiled in. -Ursprüngliche Nachricht- Von: Gopalan M [mailto:mgopa...@sofist.com] Gesendet: Mittwoch, 19. März 2014 10:46 An: sqlite-users@sqlite.org; supp...@sqlite.org Betreff: [sqlite] Snippet function with

[sqlite] Snippet function with Distinct query fails

2014-03-19 Thread Gopalan M
Sir, am using the Snippet function in my SQL select command to get a list of snippets matching my text search. This query works fine under LINUX. *QUERY* select distinct judge, snippet(VjudgeS,'','') from vjudges where judge MATCH 'Shah' However, it fails in windows. Please let me know what the