ERR: Attempt to write on read-only database

[genie]

My database works perfectly on development mode and on the simulator... but when I deploy the app to the device, I cannot do UPDATEs and INSERTs.

Code: Select all

   dbConnect
   put getDbID() into tDatabaseID

   put "UPDATE subjects SET email='" & vemail & "', birthdate='" & vdate & "', height='" & vheight & "', weight='" & vweight & "',  firstname='" & vfname & "', lastname='" & vlname & "', distributor='" & vdistnum & "', gender='" & vgender & "', smoker='" & vsmoker & "', fruitserving='" & vfruits & "', vegeserving='" & vvege & "' WHERE email='" & gEmail & "'" into tSQL

   revExecuteSQL tDatabaseID, tSQL
   answer the result  -- {attempt to write on read-only database}

What can I do so that users can have write permissions to the DB?

[Mark]

Hi,

Have you included the database file in your standalone?

Kind regards,

Mark

[genie]

Hi Mark!

Thanks for your response...

Yes! I have included my .sqlite file in the standalone, under 'copy files'. In fact, I can retrieve data out of my table...I just can't modify anything in it.

This piece of code can retrieve data...

Code: Select all

   dbConnect
   put getDbID() into tDatabaseID
   put revDataFromQuery(tab,return,tDatabaseID,"SELECT * FROM subjects") into tRecords
   answer tRecords

but this one returns error...

Code: Select all

   dbConnect
   put getDbID() into tDatabaseID
   put "UPDATE subjects SET email='" & vemail & "', birthdate='" & vdate & "', height='" & vheight & "', weight='" & vweight & "',  firstname='" & vfname & "', lastname='" & vlname & "', distributor='" & vdistnum & "', gender='" & vgender & "', smoker='" & vsmoker & "', fruitserving='" & vfruits & "', vegeserving='" & vvege & "' WHERE email='" & gEmail & "'" into tSQL  
   revExecuteSQL tDatabaseID, tSQL

[Klaus]

Hi genie,

sounds like you only added your DB file with the "Copy files" tab of the standalone maker, right?
In that case your db will be in:
...
specialfolderpath("engine") &"/your_db_file.db"
...
But you do not have WRITE permission in that folder, you can only read!
That's why a "select" will work, but an "update" (write recoreds/changes) will not.

EDITED because Bernd is SO mean

Copy your DB file to the DOCUMENTS folder and you are done:

Code: Select all

on preopenstack
  put specialfolderpath("documents") & "/your_db_file.db" into tDB
  put specialfolderpath("engine") &"/your_db_file.db" into tDBINLINE
  if there is NOT a FILE tDB then
      put url("binfile:" & tDBINLINE) into url("binfile:" & tDB)
  end if
## Now you can refer to that file and and also WRITE to the db
...
end preopenstack

This must have been discussed for at least 500 times in the iOS forum (sic!)

Best

Klaus (das alte Fickel)

P.S.
Bernd is dohf!

[bn]

Hi Klaus,

This must have been discussed for at least 500 times in the iOS forum

sure but this is the first time we test for

Code: Select all

if there is NOT a fikel tDB then

or

Code: Select all

put ul("binfile:" & tDBINLINE) into url("bifile:" & tDB)

the amazing richness of the language

kind regards
Bernd (the fikel)

please delete this post once the fikel is gone, just could not resist and did not even try to, either

[Klaus]

[genie]

Whoah! I see... I did not know "engine" is read-only. haha

Thanks much for your help, Klaus!


Regards,
genie

[Klaus]

Hi genie,

I did not know "engine" is read-only.

well, checking the "iOS Release Notes" from time to time isn't a bad idea actually...


Best

Klaus