I followed the code from the example in lesson 3.
When connecting to the SQLite (contacts.sqlite) database (which is located in the "documents" folder in Win
I get this error message:"revdberr,Database Error: near "tSQLQuery": syntax error"
Any ideas? Thanks.
Here is the code for the card "contacts":
local sDatabaseConnectionID
on preOpenCard
# mobGUIStart ---> Inserted by mobGUI plugin
if "MobGUILib-1394918029138" is not among the lines of the stacksInUse then start using stack "MobGUILib-1394918029138"
mobGUIPreOpenCard me
# mobGUIEnd
set the utext of group "title" to "contacts"
end preOpenCard
on databaseConnect pType
if pType is "SQLite" then
put specialFolderPath("documents") & "/contacts.sqlite" into tDatabasePath
put revOpenDatabase ("sqlite",tDatabasePath,,,) into sDatabaseConnectionID
else if pType is "Direct MySQL" then
else if pType is "Web MySQL" then
end if
end databaseConnect
on databaseSelectAllNames
if the uOptionText of group "databaseType" is "SQLite" or the uOptionText of group "databaseType" is "Direct MySQL" then
put empty into field "contacts"
put "SELECT firstname,lastname,contact_id FROM contacts" into tQSLQuery
put revDataFromQuery(comma,return,sDatabaseConnectionID,tSQLQuery) into tContacts
put tContacts into field "contacts"
end if
end databaseSelectAllNames