Sql: Difference between revisions

From NSB App Studio
Jump to navigation Jump to search
→‎Description: Adding more detail to sqlList
Line 28: Line 28:
(a table is dropped and added)
(a table is dropped and added)
</pre>
</pre>
== Related Items ==
[[SqlOpenDatabase]][[SQLite Reference]][[Using SQLite]]


[[Category:Language Reference]]
[[Category:Language Reference]]


[[Category:Miscellaneous]]
[[Category:Miscellaneous]]

Revision as of 14:08, 25 October 2013

Sql(db, sqlList)

Description

The Sql statement is used to send a transaction (a list of SQL commands) to SQLite. Db is the reference returned by an SQLOpenDataBase function. sqlList is an array of strings containing SQL statements to execute, or an array of arrays. In the case of an array of arrays, each entry should be of the following form:

[sqlStatement, successCallback, errorCallback]

sqlStatement is a string containing the SQL statement to execute. successCallback is a function which is called after the statement has finished executing. errorCallback is a function which is called if an error occurred while executing the statement.

For more information, see Using SQLite.

Example

Rem Sql statement sample
sqlList=[]
sqlList[0]=["Drop Table customerData;",,skipError]
sqlList[1]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"]
Sql DB, sqlList

Output

(a table is dropped and added)

Related Items

SqlOpenDatabaseSQLite ReferenceUsing SQLite