Hey everybody! I want to print my some data from my stored info in my device. I have this written:
for row in db:nrows("SELECT \* FROM Students2, SessionSumRest, EjercicioSR WHERE Students2.stu\_id = SessionSumRest.stu\_id AND SessionSumRest.sec\_id = EjercicioSR.sec\_SR\_ID") do
local txt\_stuID = row.stu\_id
local txt\_stuName = row.stu\_name
local txt\_sesID = row.sec\_id
local txt\_fechIni = row.sec\_fecha\_ini
local txt\_fechFin = row.sec\_fecha\_fin
local txt\_ejeID = row.ejercicio\_id
local txt\_numFail = row.num\_fail
local txt\_numInt = row.num\_intent
TextUser = display.newText("Stu Id: "..tostring(txt\_stuID).." Name: "..tostring(txt\_stuName).. " sesID: ".. tostring(txt\_sesID).. " ejeID: " .. tostring(txt\_ejeID).." # fail: "..tostring(txt\_numFail).." # intento: "..tostring(txt\_numInt), 25, 50\*j, native.systemFont, 24)
j=j+1
end And for some reason only 1 line is showing… instead of going threw every row. Is the code written correctly? [import]uid: 123133 topic_id: 35668 reply_id: 335668[/import]