I had a play yesterday with your script.
WIth your sqlite db it is indeed blistering fast.
I made a separate db with my data and if i change the db and column names accordingly in your test stack then it gives an error --> near ";": syntax error and the text from clipboard is then --> INSERT INTO `mydb` (`id`,`yo`,`man`) VALUES
;
if i omit the semicolon then it gies --> Your query failed! Reason: incomplete input.
2nd I tested with embedding my sqlite db in the stack, now in the IDE it sees the file (i check) and puts it perfectly in the DG.
But on Android it does see the file (i have to use specialfolder("engine") ), but does not do anything further with it. (yes all standalone dependencies are selected).
Code: Select all
put specialFolderPath("engine") & "/mydb.sqlite" into tHistDB
if there is not a file tHistDB then
answer "Local DB file not found" --just for test
else
if there is a file tHistDB then
answer "Local DB file is here" --just for test
put revOpenDatabase("sqlite", tHistDB, , , , ) into tLocalDbID
put "SELECT * FROM mytable" into tSQp
put revDataFromQuery(tab,return,tLocalDbID,tSQp) into tThis
Your stack also gave me another idea, of which i never did make use of till now and that is to add the data as a Customkey in the stack inspector and call it with the line: put the cData of this stack into theData. (never thought about it, because i always wanted to be able to update from external db)
For now this is good and also extremely fast.
And later on i can re-add the sqlite fast function when i want to add my further options to the stack. I takes minor adjustments then. So i have time to play with your written function further.
Thanks for your insights! I Appreciate it!