Hi,
I am trying to write an application that requires to import data upon startup, I have successfully imported the data using the network.request feature. The returned file is composed of a few thousand lines which are all sqlite commands which I than parse and execute one line at a time. This all works great except that it takes about 10 seconds to execute so I want to give the user feed back. I have put in a condition that should display progress but it only displays my newText fields at the end of the execution. The print happens in a timely matter but not the display.newText ??? here is the code, what am I doing wrong and how can I fix this?
x=1
myText = {}
while (string.find(Statement, “;”)) do
execStatment = Statement:sub(1, string.find(Statement, “;”))
Statement = Statement:sub(string.find(Statement, “;”)+1)
db:exec(execStatment)
if (string.find(execStatment, “DROP TABLE”)) then
myText[x] = display.newText(“Importing “…execStatment:sub(string.find(execStatment, “DROP TABLE”)+11, string.find(execStatment, “;”)-1)…” information.”, 0, 0, native.systemfont, 16)
myText[x].x = display.contentCenterX
myText[x]:setTextColor(0,0,0)
if (x==1) then
myText[x].y = myText[x].height/2
else
myText[x].y = myText[x-1].y + (myText[x].height/2) + 5
end
x=x+1
– print(“Importing “…execStatment:sub(string.find(execStatment, “DROP TABLE”)+11, string.find(execStatment, “;”)-1)…” information.”)
end
end
Thanks in advance. [import]uid: 97768 topic_id: 17511 reply_id: 317511[/import]