Hi all,
My code is below:
i have almost 100.000 record.
Code is working for 8-9 k record then i am getting error:
[lua]db:exec(“BEGIN TRANSACTION;”)
goInsert = function()
local tablefill =“INSERT INTO Data VALUES (NULL,” …Data[i].item … “,” … Data[i].Price … “)”
db:exec( tablefill )
callMe()
end
callMe=function()
if i i=i+ 1
goInsert()
end
end
if i== 0 then
cagir()
end
db:exec(“END TRANSACTION;”)[/lua]
C:\Users\user1\AppData\Roaming\Corona Labs\Corona Simulator\Plugins\mobdebug.lua:411: stack overflow
stack traceback:
[C]: in function ‘getinfo’
C:\Users\user1\AppData\Roaming\Corona Labs\Corona Simulator\Plugins\mobdebug.lua:411: in function ‘stack_depth’
C:\Users\user1\AppData\Roaming\Corona Labs\Corona Simulator\Plugins\mobdebug.lua:555: in function <C:\Users\user1\AppData\Roaming\Corona Labs\Corona Simulator\Plugins\mobdebug.lua:490>
c:\users\user1\documents\corona projects\project1\main.lua:328: in function ‘goInsert’
c:\users\user1\documents\corona projects\project1\main.lua:338: in function ‘callMe’
c:\users\user1\documents\corona projects\project1\main.lua:330: in function ‘goInsert’
c:\users\user1\documents\corona projects\project1\main.lua:338: in function ‘callMe’
c:\users\user1\documents\corona projects\project1\main.lua:330: in function ‘goInsert’
c:\users\user1\documents\corona projects\project1\main.lua:338: in function ‘callMe’
c:\users\user1\documents\corona projects\project1\main.lua:330: in function ‘goInsert’
…
c:\users\user1\documents\corona projects\project1\main.lua:338: in function ‘callMe’
c:\users\user1\documents\corona projects\project1\main.lua:330: in function ‘goInsert’
c:\users\user1\documents\corona projects\project1\main.lua:338: in function ‘callMe’
c:\users\user1\documents\corona projects\project1\main.lua:330: in function ‘goInsert’
c:\users\user1\documents\corona projects\project1\main.lua:338: in function ‘callMe’
c:\users\user1\documents\corona projects\project1\main.lua:330: in function ‘goInsert’
c:\users\user1\documents\corona projects\project1\main.lua:338: in function ‘callMe’
c:\users\user1\documents\corona projects\project1\main.lua:330: in function ‘goInsert’
c:\users\user1\documents\corona projects\project1\main.lua:338: in function ‘callMe’
c:\users\user1\documents\corona projects\project1\main.lua:342: in function <c:\users\user1\documents\corona projects\project1\main.lua:313>
how can i solve this issue?
Thanks in advice…
PS: My lua code is swowing one line. so i inserted to code screen shot.