B4J Question ExecNonQuery

[codie01]

Hi all,

I know how to insert data coded as such:

sql1.ExecNonQuery2("INSERT INTO sites VALUES(?,?,?,?,?,?,?,?,?)", Array As Object(site_ID.Text, site_Display.Text, site_Subdivision.Text, site_Lot.Text, _
    site_Box.Text, site_Address.Text, site_Suburb.Text, site_City.Text, site_Postcode.Text))

How do use ExecNonQuery2("UPDATE") to update a record.

Thanks in advance.

 

[Erel]

sql1.ExecNonQuery2("UPDATE sites SET col1 = ? WHERE col2 = ?", Array("abc", "def"))

http://www.w3schools.com/sql/sql_update.asp

 

[codie01]

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:

       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())

 

[codie01]

Good Day Erel,

I have solved this problem and all works. Thanks

Phil