Sql: Difference between revisions
Jump to navigation
Jump to search
| Line 20: | Line 20: | ||
sqlList[0]=["Drop Table customerData;",,skipError] | sqlList[0]=["Drop Table customerData;",,skipError] | ||
sqlList[1]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"] | sqlList[1]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"] | ||
Sql DB, sqlList | Sql(DB, sqlList) | ||
</pre> | </pre> | ||
Revision as of 15: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)