accessing database table on iPad
Frantz Charles
fzcharles0214 at hotmail.com
Tue Sep 16 21:27:54 EDT 2014
To all,
I need your expertise help to solve this issue I encounter in the app I am creating. Here is the problem:I create a SQLite database with 2 tables containing data. The database is saved in the same folder than the app. I can access with ease the database and read the records from my desktop. But when I test the app with the emulator or with my iPad, even though a database id is returned - proof that the database is open - I got the following error: revdberr, Database Error: No such table Histoire" . Here are my codes.Here are the codes to open the database:# Open the databaseput "/users/frantzcharles/Documents/All About LiveCode/Cric-Crac/CricCracDB.sqlite" into thePathput "/CricCracDB.sqlite" into theMobilePathif the environment = "mobile" then if there is not a file (specialFolderPath("Documents") & theMobilePath) then put (specialFolderPath("engine") & theMobilePath) into sPath put url ("binfile:" & sPath) into dPath put dPath into url ("binfile:" & (specialFolderPath("Documents") & theMobilePath)) end if put (specialFolderPath("Documents") & "/CricCracDB.sqlite") into tDBPath put revOpenDatabase("sqlite", tDBPath ,,,,,,) into tConIDelse ## this is not mobile put revOpenDatabase("sqlite", thePath ,,,,,,) into tConIDend ifHere are the codes to access the tableput "Select Hist_Question from Histoire where Hist_Id = " & tNextQ into tSQL put revdb_querylist(,,g_ConID, tSQL) into tList
I am missing something. Which I can not put my finger on. Can any of you help me? Thanks a lot
Frantz
More information about the use-livecode
mailing list