SqlExport: Difference between revisions
Jump to navigation
Jump to search
(Created page with "SQLEXPORT(''db''[, ''filename''[, ''function'']]) '''Description''' The SQLExport function converts an SQLite database to a JSON object. This object can then be sent to anot...") |
|||
| (9 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
SQLExport(''db''[, ''filename''[, ''function'']]) | |||
== Description == | |||
The SQLExport function | The SQLExport function returns an SQLite database to a JSON object. This object can then be sent to another server using AJAX. | ||
To include your own ''filename'', include it as the second parameter. If nothing is suppled, ‘default’ will be used. | To include your own ''filename'', include it as the second parameter. If nothing is suppled, ‘default’ will be used. | ||
| Line 11: | Line 11: | ||
SQLExport is used by the IDE to convert databases listed in the manifest to JavaScript files which are included in the project. | SQLExport is used by the IDE to convert databases listed in the manifest to JavaScript files which are included in the project. | ||
For more information on SQLite, see [[Using SQLite]]. | |||
== Example == | |||
<pre> | <pre> | ||
Function btnSQLExport_onclick() | Function btnSQLExport_onclick() | ||
NSB.ShowProgress("Exporting database...") | NSB.ShowProgress("Exporting database...") | ||
DBjson=SQLExport(DB, exportComplete) | DBjson=SQLExport(DB, "customer.db", exportComplete) | ||
End Function | End Function | ||
| Line 23: | Line 25: | ||
MsgBox JSON.stringify(DBjson) | MsgBox JSON.stringify(DBjson) | ||
End Function | End Function | ||
<pre> | </pre> | ||
== Output == | |||
<pre> | <pre> | ||
| Line 31: | Line 33: | ||
</pre> | </pre> | ||
== Related Items == | |||
[[sqlimport|SQLImport]] | |||
[[Category:Language Reference]] | |||
[[ | [[Category:Miscellaneous]] | ||
Latest revision as of 16:26, 27 February 2017
SQLExport(db[, filename[, function]])
Description
The SQLExport function returns an SQLite database to a JSON object. This object can then be sent to another server using AJAX.
To include your own filename, include it as the second parameter. If nothing is suppled, ‘default’ will be used.
Since it can take some time to do the conversion with large databases, the SQLExport returns immediately and continues to run in the background. When it is complete, function is called in your app.
SQLExport is used by the IDE to convert databases listed in the manifest to JavaScript files which are included in the project.
For more information on SQLite, see Using SQLite.
Example
Function btnSQLExport_onclick()
NSB.ShowProgress("Exporting database...")
DBjson=SQLExport(DB, "customer.db", exportComplete)
End Function
Function exportComplete()
NSB.ShowProgress(False)
MsgBox JSON.stringify(DBjson)
End Function
Output
(a MsgBox showing the converted data as a string)