basically I just wanted to identify if a row is empty.
database sample:
Testing :
ID | boompanes | shimag |
---------------------------------------------------------|
1 | asdads | asdasd |
here is my code :
--row number b = 2 for row in db:nrows([[SELECT \* FROM Testing WHERE id = ']]..b..[[']]) do a=a+1 print("\n\n\n\n\n\n\n"..row.id.."\n\n\n\n\n\n") if row.id == nil then pak = display.newText("PAK", 100,200, native.font, 32) pak:setFillColor(1,0,0) pak.y = pak.y+50\*a else kap = display.newText("KAP", 200,300, native.font, 32) kap:setFillColor(0,1,0) kap.y = kap.y+50\*a end end
there are no errors here but the problem is when b’s values is 2 or more, it doesn’t display anything on the console, however if b is 1 it returns the row id which is 1. The way I see it, it doesn’t see it as a nil value, but the program see’s it as an empty field