barrymavin
2012-10-31, 05:29
With the introduction of Virtual Tables in Beta10, if you have a need to query data from any native lianja or other third party data source and export it into HTML, JSON or XML you can do it in one command like this.
select * from mytable where accno="xzy" into html filename.htm
select * from mytable where accno="xzy" into json filename.json
select * from mytable where accno="xzy" into html filename.xml
If you need to output this into a WebView you can do this in one command like this.
select * from mytable where accno="xzy" into html console
select * from mytable where accno="xzy" into json console
select * from mytable where accno="xzy" into html console
Quite a time saver.
select * from mytable where accno="xzy" into html filename.htm
select * from mytable where accno="xzy" into json filename.json
select * from mytable where accno="xzy" into html filename.xml
If you need to output this into a WebView you can do this in one command like this.
select * from mytable where accno="xzy" into html console
select * from mytable where accno="xzy" into json console
select * from mytable where accno="xzy" into html console
Quite a time saver.