B4J Question ExecNonQuery

Discussion in 'B4J Questions' started by codie01, Jul 10, 2015.

  1. codie01

    codie01 Member Licensed User

    Hi all,

    I know how to insert data coded as such:

    Code:
    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.
     
  2. Erel

    Erel Administrator Staff Member Licensed User

  3. codie01

    codie01 Member Licensed User

    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:

    Code:
    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())
     
  4. codie01

    codie01 Member Licensed User

    Good Day Erel,

    I have solved this problem and all works. Thanks

    Phil
     
Loading...