Hello,
I’m new to Corona and have run into a bit of a snag.
Trying to create an app that will display contacts with comments.
when showing the data from a sqlite db, I’ve managed to get the data to show and the text from the comments to wrap to the next line. However, the next row in the DB will cover the previous record’s wrapped text.
Can anyone tell me what I am doing wrong here? By the way I am using windows.
–setting the font size & text display size
local fSize = display.contentWidth * .03
local tTab = display.contentWidth * .05
local tWidth = display.contentWidth * .9
local tTop = display.contentHeight * .1
local count =0
local sql = “SELECT * from contacts”
for row in db:nrows(sql) do
if row.name == nil then
print(" NO NAME FOUND!!! ")
end
count = count +1
local dbText = row.name…" - “…row.phone…” - "…row.comment
local t = display.newText(dbText, tTab, tTop + ((fSize * 1.25) + (fSize * 1.25 * count)), tWidth, 0, native.systemFont, fSize)
t:setTextColor(255,255,255)
end