SqlImport
result = SQLImport(JSON, [DB], [callback], [overwrite])
Description
SqlImport converts a JSON object created using SqlExport into an SQLite database. The JSON object can come from an Ajax call or from any code which generates a valid JSON object.
SqlImport may report errors if the database used by SqlExport has features that are not supported on the current platform, or if the syntax of the Json is invalid. For example, Safari (at the time of this writing) does not support timestamp in constraints, images or indexes. Embedded carriage returns in string fields will also cause errors.You will need to remove these items from the database before doing SqlExport.
DB is an optional argument. If supplied, the reference to the database is assigned to it. There is no need to do an SqlOpenDatabase. It can be left empty if not needed.
callback is the name of a function to be called when the import is complete. If it is not supplied,execution will be blocked until the import is completed.
overwrite can have the following values:
| Value | Action |
|---|---|
| true | overwrite the existing database (default). |
| false | only write out database if it does not exist yet. |
| overwriteDifferent | overwrite if the version number of the database has changed. |
| overwriteSame | overwrite if the version number of the database is the same. |
result is a string which returns whether the operation was successful.
To change the version of a database, use the command DB.changeVersion(oldVersionString, newVersionString).
For more information on SQLite, see Using SQLite.
Example
Function btnSQLImport_onclick()
SQLImport(DBjson, DB)
'refresh the selection
sqlList=Array(["SELECT * from customerData ORDER BY name;", dataHandler])
Sql(DB, sqlList)
End Function
Output
(the database is imported and a selection is made)