Monday, February 27, 2012

Perfect Json out from Sqlite3

Going in from the browser query window:
{$RunTable@SystemExec,select * from test;}

Coming out, a Json encoded square table:
{0.1.Row0},{1.2.Row3},{0.1.Row5},{2.3.Row4}
The intermediate form is a Qson table in Sqlite3. Any table in sqlite is presentable as an html table, and can be loaded into an Html widget.

No comments: