Sql: Difference between revisions
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
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 a SQLite command or an array of SQLite commands. | 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 a SQLite command or an array of SQLite commands. | ||
For more information, see [[ | For more information, see [[Using SQLite]]. | ||
== Example == | == Example == | ||
Revision as of 13:51, 12 November 2012
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 a SQLite command or an array of SQLite commands.
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)