Thanks Erel, you work tirelessly, thanks it worked nicely.
One last one I think and it all works. When the database is updated I want to change the selected row to match. Code to do this but does not work is as follows:
B4X:
col1=site_ID.Text
col2=site_Display.Text
col3=site_Subdivision.Text
col4=site_Lot.Text
col5=site_Box.Text
col6=site_Address.Text
col7=site_Suburb.Text
col8=site_City.Text
col9=site_Postcode.Text
sql1.ExecNonQuery2("UPDATE sites SET site_ID = ?, site_Display = ?, site_Subdivision = ?, site_Lot = ? WHERE site_ID = " & mymatch, Array(site_ID.Text, site_Display.Text, site_Subdivision.Text, site_Lot.Text))
' ------ Does not work from here down to change tableview row.
Dim row As Int
row = site_Table.SelectedRow
Dim rowcontent() As Object = site_Table.Items.get(row)
rowcontent(1) = site_Display.Text
site_Table.SelectedRowValues(), As Object(rowcontent())