Talk:Sql: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Answering a question on the sample. |
||
| Line 1: | Line 1: | ||
== Help With Example == | |||
<pre> | |||
sqlList=[] | sqlList=[] | ||
sqlList[0]=["Drop Table customerData;",,skipError] | sqlList[0]=["Drop Table customerData;",,skipError] | ||
sqlList[1]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"] | sqlList[1]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"] | ||
Sql DB, sqlList | Sql DB, sqlList | ||
</pre> | |||
the code don't work | the code don't work | ||
| Line 13: | Line 11: | ||
anyone know the correct code? | 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]]. --[[User:James|James]] ([[User talk:James|talk]]) 12:17, 3 July 2013 (EDT) | |||
Latest revision as of 16:17, 3 July 2013
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)