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 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)
Related Items