preOpenStack or openStack

[Turtle]

Hi everyone,
Again it is me with the files problem
Ok, first i got problem opening the database file, but then i found a topic in the forum which helped me to understand why i need to copy my sqlite file before trying to use it.
Now, my question is this... is it a good idea to call my dataDbConnect function in preOpenStack? Please see the code bellow.

Code: Select all

on dataDbConnect
   put specialfolderpath("resources") & "/data.sqlite" into tDatabasePath
   put  specialfolderpath("Documents") & "/data.sqlite" into tAccessibleDatabasePath
   -- copy it out of the application folder if you dont want to spend your hours pulling your hair
   --trying to understand whats wrong
    put URL ("binfile:" & tDatabasePath) into URL ("binfile:" & tAccessibleDatabasePath)

   put revOpenDatabase("sqlite", tAccessibleDatabasePath, , , , ) into tID
   answer tID
   put tID into gDataDbID
   
end dataDbConnect

Also one more question, is it necessary to add some application permission for reading and writing files in documents file?
Thanks

[Klaus]

Hi Turtle,

... is it a good idea to call my dataDbConnect function in preOpenStack?

no problem in the IDE, but in a standalone this might not work, due to the way LC loads its externals like the database driver. In that case I would:

Code: Select all

on preopenstack
  ## your preopenstack stuff here...
  send "dataDbConnect" to me in 30 
  ## = 30 ticks = 0.5 seconds  
end preopenstack

This way the engine has time to load all externals etc.

... is it necessary to add some application permission for reading and writing files in documents file?

Sorry, don't understand your question? "documents file"?


Best

Klaus

[dunbarx]

Klaus.

I guess he means the documents folder, not file. This folder is unfettered, and usually does not require any special treatment regarding permissions, correct?..

Craig

[SparkOut]

On mobile maybe you need to ensure the right permissions and inclusions are specified in the standalone settings.
Oh and for the handler above, perhaps you would need a check for the existence of the accessible database file in the documents folder, and only do the copy from resources folder if it isn't there. Otherwise every time you open the stack the database will be overwritten with the original empty one.

[Turtle]

Hi, everyone.
I have been very busy, sorry guys. Thank you all for the answers, yes i meant the documents folder )) lol