Looking for a Dialog Example with Interactive List Filtering

[lionking]

For some reason the dialog function gave me error when running, so I modified just the SQL string a litte bit and it works just fine.

Function dlg_list_filtering_tag

Code:

Copy      Help

;create an example table and add several items
if createTableNow
,str sql=
,;PRAGMA journal_mode=WAL;
,;BEGIN;
,;DROP TABLE IF EXISTS t;
,;CREATE TABLE t(name,tag);
,;INSERT INTO t(name,tag) VALUES('January','month');
,;INSERT INTO t(name,tag) VALUES('Apple','fruit');
,;INSERT INTO t(name,tag) VALUES('Banana','fruit');
,;INSERT INTO t(name,tag) VALUES('April','month');
,;INSERT INTO t(name,tag) VALUES('Other','');
,;COMMIT;
,db.Exec(sql)