Page 1 of 1
sqlite database Issue
Posted: Sat Dec 10, 2011 11:51 pm
by 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
Re: sqlite database Issue
Posted: Sun Dec 11, 2011 12:34 am
by Jellicle
FireWorx wrote: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
Re: sqlite database Issue
Posted: Sun Dec 11, 2011 12:35 am
by 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
Re: sqlite database Issue
Posted: Sun Dec 11, 2011 9:51 pm
by FireWorx
Thank you. I will give it another try.
Dave
Re: sqlite database Issue
Posted: Fri Dec 16, 2011 11:43 am
by Informatie