DB Data Not Displaying with Widgets 2.0 TableView

rozan · May 31, 2013, 3:18am

I think that I’ve got my code almost figured out, but my simulator screen remains blank. Although, it responds as if the data is there (scrolls a long way).

I did a print test near the bottom of my code and the database does appear on the output window.

Here are the last few lines of my code:

print ( listRecs[x].rowid, listRecs[x].date, listRecs[x].title ) end end -- showRecords db = setUpDatabase("mydatabase.sqlite") setupInterface() loadData() showRecords()

And, like I said, that print statement spits out the correct data. I have wondered if it’s a color problem, but I don’t know enough, I guess. I think this is the relevant code for the display problem. If I should look somewhere else, please let me know.

local function showRecords() local function onRowRender( event ) local phase = event.phase local row = event.row local rowGroup = event.view local idx = event.index --add event.index to work with widgets 2.0 local color = {0,0,0} --widgets 2.0 db:insertRow{ -- changed list to db rowHeight=rowHeight, isCategory=isCategory, --rowColor=rowColor, lineColor=lineColor, } -- title to display row.textObj = display.newRetinaText( listRecs[idx].title, 0, 0, "Helvetica", 16 ) row.textObj:setTextColor( color ) row.textObj:setReferencePoint( display.CenterLeftReferencePoint ) row.textObj.x = 20 row.textObj.y = rowGroup.contentHeight \* 0.35 -- add date to display row.textObj2 = display.newRetinaText( listRecs[idx].date, 0, 0, "Helvetica", 12 ) row.textObj2:setTextColor( color ) row.textObj2:setReferencePoint( display.CenterLeftReferencePoint ) row.textObj2.x = 20 row.textObj2.y = rowGroup.contentHeight \* 0.65 local function delRow( event ) print("Delete hit: " .. tostring(event.target.id)) local dbid = listRecs[event.target.id].id list:deleteRow(event.target.id) --remove from list widget table.remove(listRecs, event.target.id) --remove from table display.remove( detailGrp ) -- delete from database function deletData(id) local sql = "delete from News where id = " .. tostring(id) db:exec(sql) end deleteData(dbid) -- end row.delButton = widget.newButton{ -- check with Widgets 2.0 docs id = row.index, top = rowGroup.contentHeight \* 0.2, left = rowGroup.contentWidth - 90, default = "deletebtn.png", width = 64, height = 33, onRelease = delRow } row.delButton.alpha = 0 if listRecs[idx].showDel == true then row.delButton.alpha = 1 end rowGroup:insert(row.delButton) rowGroup:insert(row.textObj) rowGroup:insert(row.textObj2) -- display doesn't work. Refer to Widgets 2.0 documentation end --onRowRender local function rowListener( event ) local background = event.background local row = event.row local phase = event.phase if phase == "press" then print( "Pressed row: " .. row.index ) background:setFillColor( 196, 255, 156, 255 ) elseif phase == "release" or phase == "tap" then print( "Tapped and/or Released row: " .. row.index ) background:setFillColor( 196, 255, 156, 255 ) row.reRender = true -- go to new scene or add details to part of screen showDetails(row.index) elseif phase == "swipeLeft" then print( "Swiped Left row: " .. row.index ) listRecs[row.index].showDel = true row.reRender = true elseif phase == "swipeRight" then print( "Swiped Right row: " .. row.index ) listRecs[row.index].showDel = false display.remove( row.delButton ) end end -- rowListener for x = 1, #listRecs do list:insertRow { onRender = onRowRender, listener = rowListener } print ( listRecs[x].rowid, listRecs[x].date, listRecs[x].title ) end end -- showRecords

elbowroomapps · May 31, 2013, 5:54am

It looks like you’re using rowGroup = event.view and I think that’s one of the things that was deleted from widgets 2.0. Try just inserting the objects into row instead of rowGroup, and see if that works.

rozan · May 31, 2013, 1:31pm

Thank. I tried that, and it still does not work. I was wondering about this line:

row.textObj = display.newRetinaText( listRecs[idx].title, 0, 0, "Helvetica", 16 ) &nbsp; In Widgets 2.0, there is this sample: local function onRowUpdate( event ) local row = event.row print( "Row:", row.index, " is now visible" ) end -- Handle touches on the row local function onRowTouch( event ) local phase = event.phase if "press" == phase then print( "Touched row:", event.target.index ) end end

So, I was wondering if I should take out the [idx], because the index of the row appears built in to tableView. If so, should the line be something like this:

row.textObj = display.newRetinaText( listRecs.index.title, 0, 0, “Helvetica”, 16 )

although, I did try that and it did not work. It just seems that perhaps the index that appears built in may be the key issue.

elbowroomapps · June 1, 2013, 6:22am

Are you seeing anything in your tableView? Did you try printing idx to confirm that it’s set to what you expected?

rob · June 1, 2013, 1:55pm

Your rowRender function gets called when you insert Rows into the table. It looks like your insert rows is inside your rowRender function. This needs to be outside of that function and run by some other part of your code.

rozan · June 1, 2013, 11:33pm

Thanks for your help. I have moved the insert rows section to a separate function below rowRender. I have called that function at the location where it was previously, as shown below. And, I tried the print function below the insertRow function call. I don’t know if that is the right place, because I get an error, that it is a nil value. (I tried it with the x, and with idx from the code above. I am totally confused, sorry)

function showRecords () &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local function onRowRender( event ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local phase = event.phase &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local row = event.row &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local rowGroup = event.view &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local idx = event.index --add event.index to work with widgets 2.0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local color = {0,0,0} &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --widgets 2.0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db:insertRow{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- changed list to db&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rowHeight=rowHeight, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; isCategory=isCategory, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --rowColor=rowColor, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lineColor=lineColor, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- title to display &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.textObj = display.newRetinaText( listRecs[idx].title, 0, 0, "Helvetica", 16 ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.textObj:setTextColor( color ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.textObj:setReferencePoint( display.CenterLeftReferencePoint ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.textObj.x = 20 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.textObj.y = row.contentHeight \* 0.35&nbsp; --was rowGroup &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- add date to display &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.textObj2 = display.newRetinaText( listRecs[idx].date, 0, 0, "Helvetica", 12 ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.textObj2:setTextColor( color ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.textObj2:setReferencePoint( display.CenterLeftReferencePoint ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.textObj2.x = 20 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.textObj2.y = row.contentHeight \* 0.65&nbsp; --was rowGroup &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local function delRow( event ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print("Delete hit: " .. tostring(event.target.id)) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local dbid = listRecs[event.target.id].id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; list:deleteRow(event.target.id) --remove from list widget &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; table.remove(listRecs, event.target.id) --remove from table &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; display.remove( detailGrp ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- delete from database &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; function deletData(id) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local sql = "delete from News where id = " .. tostring(id) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db:exec(sql) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; deleteData(dbid) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.delButton = widget.newButton{&nbsp; -- check with Widgets 2.0 docs &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id = row.index, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; top = row.contentHeight \* 0.2,&nbsp;&nbsp;&nbsp; --was rowGroup &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; left = row.contentWidth - 90,&nbsp; --was rowGroup &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; default = "deletebtn.png", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; width = 64, height = 33, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; onRelease = delRow &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.delButton.alpha = 0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if listRecs[idx].showDel == true then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.delButton.alpha = 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row:insert(row.delButton)&nbsp; --was rowGroup &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row:insert(row.textObj)&nbsp; --was rowGroup &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row:insert(row.textObj2)&nbsp; --was rowGroup &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end --onRowRender &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local function rowListener( event ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local background = event.background &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local row = event.row &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; local phase = event.phase &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if phase == "press" then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print( "Pressed row: " .. row.index ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; background:setFillColor( 196, 255, 156, 255 ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; elseif phase == "release" or phase == "tap" then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print( "Tapped and/or Released row: " .. row.index ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; background:setFillColor( 196, 255, 156, 255 ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.reRender = true &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- go to new scene or add details to part of screen &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; showDetails(row.index) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; elseif phase == "swipeLeft" then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print( "Swiped Left row: " .. row.index ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; listRecs[row.index].showDel = true &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.reRender = true &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; elseif phase == "swipeRight" then &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print( "Swiped Right row: " .. row.index ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; listRecs[row.index].showDel = false &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; display.remove( row.delButton ) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end -- rowListener &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; insertRow() &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print ( listRecs[x].rowid, listRecs[x].date, listRecs[x].title ) end -- showRecords function insertRow() &nbsp;&nbsp;&nbsp; for x = 1, #listRecs do &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; list:insertRow { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; onRender = onRowRender, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; listener = rowListener &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp; end end

rob · June 2, 2013, 12:46am

There isn’t enough to answer your question. I don’t see where you create the list in the first place. We can’t see the whole structure of the file. Can you post more. Please enclose the code in and tags (no spaces inside the brackets).

rozan · June 2, 2013, 1:00am

local function loadData()&nbsp; --where to load from database &nbsp;&nbsp;&nbsp; local sql = "select \* from News" &nbsp;&nbsp;&nbsp; --local a = event.row.index --added for widgets 2.0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;for a in db:nrows(sql) do &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; listRecs[#listRecs+1] = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --News[#News+1] = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rowid = a.rowid, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date = a.date, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; title = a.title, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; text = a.text &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp; end &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; return dbNew &nbsp;&nbsp; &nbsp; end

Before that I have

linePrinter function

setupDatabaseName function

setupInterface function

after loadData
function I have

showDetails function

then the showRecords function which is included above

and last the insertRow function

If any of these other ones are necessary to narrow down the problem, let me know. I only have a vague understanding sometimes of how these work together. But, I am learning more. First time programmer, and only been at it a month, so forgive me if I sound totally off.

rozan · June 3, 2013, 10:21pm

Any ideas are appreciated!!

rob · June 3, 2013, 11:14pm

What version of Corona SDK are you using?

Are you trying to use the Widget 1.0 opensource library?

Here is what a Widget 2.0 tableView should look like:

local tableView = widget.newTableView { &nbsp;&nbsp;&nbsp; top = 0, &nbsp;&nbsp;&nbsp; left = 0, &nbsp;&nbsp;&nbsp; height = display.contentHeight, &nbsp;&nbsp;&nbsp; width = display.contentWidth, &nbsp;&nbsp;&nbsp; listener = tableViewListener, &nbsp;&nbsp;&nbsp; onRowRender = onRowRender, &nbsp;&nbsp;&nbsp; onRowTouch = onRowTouch, } &nbsp; for i = 1, 30 do &nbsp;&nbsp;&nbsp; local isCategory = false &nbsp;&nbsp;&nbsp; local rowHeight = 40 &nbsp;&nbsp;&nbsp; local rowColor = &nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; default = { 255, 255, 255 }, &nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp; local lineColor = { 220, 220, 220 } &nbsp;&nbsp;&nbsp; -- Insert the row into the tableView &nbsp;&nbsp;&nbsp; tableView:insertRow &nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; isCategory = isCategory, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rowHeight = rowHeight, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rowColor = rowColor, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lineColor = lineColor, &nbsp;&nbsp;&nbsp; } end

Notice how the onRowRender is part of the tableView definition, not the insertRow call.

elbowroomapps · May 31, 2013, 5:54am