I am using the query below to update two values from a form.
MyTable can be one of two tables. When this code is executed, the table should be updated, but is not. I am unable to see why the table is not updated.Code:MasterBase.AddParam("@midno", lblMasterID.Text) MasterBase.AddParam("@effective", False) MasterBase.AddParam("@obsolete", True) MasterBase.MasterBaseQuery("UPDATE " & MyTable & " " & "SET Effective=@effective,Obsolete=@obsolete " & "WHERE MasterBaseID=@midno")
I know that queries are very tricky and I often have trouble making them work. But I do not see the error here.




Reply With Quote
