Sql: Difference between revisions
Jump to navigation
Jump to search
Line 31: | Line 31: | ||
== Related Items == | == Related Items == | ||
[[SqlOpenDatabase]] [[SQLite Reference]] [[Using SQLite]] | [[SqlOpenDatabase]] | ||
[[SQLite Reference]] | |||
[[Using SQLite]] | |||
[[Category:Language Reference]] | [[Category:Language Reference]] | ||
[[Category:Miscellaneous]] | [[Category:Miscellaneous]] |
Revision as of 14:09, 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)