0

I am currently developing a notebook application for the Android environment, however I am stuck on how to approach a SQL search interface. From conducting research, I have found the most effective approach would be to use the "Full Text Search" module (FTS4).

What I am stuck on is the way which I have to handle this. Do I have to:

  1. Create both a Note Table and a Virtual Table and use a simple Trigger logic to insert into both tables.

or

  1. Do I create a Virtual Table ONLY and maintain the list of Notes within there.
pnuts
  • 58,317
  • 11
  • 87
  • 139

1 Answers1

0

You just have to create a virtual table and maintain list of nodes within there. That is my understanding after reading FTS doc

zedfoxus
  • 35,121
  • 5
  • 64
  • 63
  • Yh I was actually thinking along the same lines to be honest as the doc wasn't clear on maintaining both tables or just one of them, thank for the answer –  Nov 22 '15 at 15:19