I have searched and cannot find an answer to my issue so i hope i am not completely barking up the wrong tree (so to speak).

I am new to android and have started to create an app. My app on one screen creates and adds entries to a SQLite database using public class DatabaseHandler extends SQLiteOpenHelper and this all appears to work.

I retrieve all the data and populate it into a grid, again this now works.

My issue is I am unable to retrieve one complete line from the grid.

I populate/display the grid with the following code.

I have cut a lot out as the grid is made in stages, header, blank lines etc but the grid does display as I want.

The id’s work as when I touch a line it displays its unique id.

The onClick is right at the end and when I use getText() instead of getID() all it returns is the data in the labelDate. How do I retrieve all the labels as listed below?

TextView labelDATE = new TextView(this);
TextView labelCP = new TextView(this);
TextView labelBG = new TextView(this);
TextView labelQA = new TextView(this);
TextView labelCN = new TextView(this);
TextView labelKT = new TextView(this);
TextView[] tvArray = {labelDATE, labelCP, labelBG, labelQA, labelCN, labelKT};
labelDATE.setText(re.getTime());
labelCP.setText(re.getCP());
labelBG.setText(re.getBG());
labelQA.setText(re.getQA());
labelCN.setText(re.getCN());
labelKT.setText(re.getKT());
for (TextView tv : tvArray)
{
    tv.setTextColor(Color.WHITE);
    tv.setId(200+count);
    tr.setOnClickListener(this);
    tr.addView(tv);
}
//add this to the table row
tl.addView(tr, new TableLayout.LayoutParams(LayoutParams.MATCH_PARENT,LayoutParams.WRAP_CONTENT));

public void onClick(View v) 
{ 
    if (v instanceof TableRow) 
    { 
        TableRow row = (TableRow) v; 
        TextView child = (TextView) row.getChildAt(0); 
        Toast toast = Toast.makeText(this, String.valueOf(child.getId()), Toast.LENGTH_SHORT); 
        toast.show();
    } 
}

I can supply all the code for the grid creation if required.

Thanks for any help.