I have an MS Access DB with a table' Isometric' . One of the columns
is named 'Sheet'. I am doin a test to see if I can change a value in
the dataset and update the Access table with the DataAdapter.Upd ate
method. It is not working:
Dim con As System.Data.Ole Db.OleDbConnect ion = DAL.GetOLECon
Dim dap As New System.Data.Ole Db.OleDbDataAda pter("SELECT *
FROM Isometric", con)
Dim cmb As New System.Data.Ole Db.OleDbCommand Builder(dap)
Dim das As New DataSet
das.Tables(0).R ows(0).Item("Sh eet") = 999
dap.Update(das, "Isometric" )
Here is the error I get
Syntax error (missing operator) in query expression '((ID_Isometric =
?) AND ((? = 1 AND Line number IS NULL) OR (Line number = ?)) AND ((? =
1 AND Sheet IS NULL) OR (Sheet = ?)) AND ((? = 1 AND Spec IS NULL) OR
(Spec = ?)) AND ((? = 1 AND Material delivered IS NULL) OR (Material
delivered = ?)) AND ((? = 1'.
is the commandbuilder just creating the update commandtext inccorectly?