View source for Sql

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|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:

<pre>
[sqlStatement, [args,] successCallback, errorCallback]
</pre>

''sqlStatement'' is a string containing the SQL statement to execute.  ''args'' is an optional string or array containing substitution values for parameters. ''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 ==

<pre>
Rem Sql statement sample
sqlList=[]
sqlList[0]=["Drop Table customerData;",,skipError]
Sql(DB, sqlList)

sqlList=[]
sqlList[0]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"]
Sql(DB, sqlList)

Function skipError(tx, err)
  Print "Error: " & err.errcode
End Function
</pre>

== Output ==

<pre>
(a table is dropped and added)
</pre>

== Related Items ==

[[SqlOpenDatabase]] 

[[SQLite Reference]] 

[[Using SQLite]]

[[Category:Language Reference]]

[[Category:Miscellaneous]]