[sqlite] Contentless FTS4 Tables

2015-05-23 Thread Dan Kennedy
On 05/23/2015 04:33 AM, ShadowMarta at yahoo.de wrote: > Hi! > > I have made a Contentless FTS4 Table like: > > "CREATE VIRTUAL TABLE if not exists OCR USING fts4(content="", `FullOCR` > varchar;" > > And managed to insert some data into it. > > I have 2 questions: > > 1.) How to get the proper

[sqlite] Contentless FTS4 Tables

2015-05-23 Thread shadowma...@yahoo.de
_docsize" gives correct result. BR, Marta -Original Message- From: Dan Kennedy Sent: Saturday, May 23, 2015 9:34 AM To: sqlite-users at mailinglists.sqlite.org Subject: Re: [sqlite] Contentless FTS4 Tables On 05/23/2015 04:33 AM, ShadowMarta at yahoo.de wrote: > Hi! > &

[sqlite] Contentless FTS4 Tables

2015-05-23 Thread shadowma...@yahoo.de
Hi! I have made a Contentless FTS4 Table like: "CREATE VIRTUAL TABLE if not exists OCR USING fts4(content="", `FullOCR` varchar;" And managed to insert some data into it. I have 2 questions: 1.) How to get the proper COUNT on the table ? The only query seems to work is: "SELECT