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:" & (speci
alFolderPath("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
_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode