Talk:Sql

From NSB App Studio
Jump to navigation Jump to search

Help With Example

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

the code don't work skipError and DB are not defined

anyone know the correct code?

The DB parameter is the return value of SqlOpenDatabase as referenced in the page. The sqlList parameter is under-documented, and I'm going to fix that on the page. In this particular case, skipError is a function that is called if an error occurs. You can see the complete definition in Using_SQLite#Complete_Sample. --James (talk) 12:17, 3 July 2013 (EDT)