Frantz,
Let's see if we get to the bottom of this.
First: If the db does not exist SQLite will create a blank one. This is the
good news! You know that your DB code is working.
You can always check if your "real" db is open by making sure one or more of
your tables is returned by the revDatabaseTableNames(databaseID) function.
Make sure you have the DB in the "copy files" pane of the standalone
settings. If so the check "the result" after the file copy.
Also this would be faster if the file is large.
put url ("binfile:" & sPath) into url ("binfile:" &
(specialFolderPath("Documents") & theMobilePath))
Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net
-----Original Message-----
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf
Of Frantz Charles
Sent: Tuesday, September 16, 2014 9:28 PM
To: use-livecode@lists.runrev.com
Subject: accessing database table on iPad
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 database
put "/users/frantzcharles/Documents/All About
LiveCode/Cric-Crac/CricCracDB.sqlite" into thePath
put "/CricCracDB.sqlite" into theMobilePath
if 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 tConID
else
## this is not mobile
put revOpenDatabase("sqlite", thePath ,,,,,,) into tConID
end if
Here are the codes to access the table
put "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
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
