Sql

From NSB App Studio
Revision as of 13:51, 12 November 2012 by Ghenne (talk | contribs) (→‎Description)
Jump to navigation Jump to search

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)