Sql: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
(→Output) |
||
Line 24: | Line 24: | ||
[[Category:Language Reference]] | [[Category:Language Reference]] | ||
[[Category:Miscellaneous]] |
Revision as of 22:30, 13 September 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 Tech Note 15.
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)