sqlite database Issue

[FireWorx]

Has anyone else out there been able to populate a sqlite database table then copy it to the engine folder and then move it to the documents folder and have it retain it's data? Seems like perhaps you have to build your schema and populate your data into the database once it exists in the documents folder and not before.

I was trying to move some data from an excel worksheet into the db with a database management tool first and then once the data was in the db move it to the iPad.

Dave

[Jellicle]

Has anyone else out there been able to populate a sqlite database table then copy it to the engine folder and then move it to the documents folder and have it retain it's data?

Yes.

Gerry

[Dixie]

Dave...

This works for me, I use it in a preOpenStack handler...

Code: Select all

   put specialFolderPath("documents") & "/localKnow.db" into dataBaseFilePath
      if there is not a file documentFilePath then
         put specialFolderPath("engine") & "/localKnow.db" into engineFilePath
         put URL ("binfile:" & engineFilePath) into URL ("binfile:" & dataBaseFilePath)
      end if

be well

Dixie

[FireWorx]

Thank you. I will give it another try.
Dave

[Informatie]

see also :

http://forums.runrev.com/viewtopic.php?f=49&t=9787

DJ