syntax error in update statement
-
Dim updateSQL As String updateSQL = "Update Product Set " & _ " Description = '" & txtDesc.text & "', " & _ :confused:" Where Code = '" & txtCode.Text & "'" Set RS = Conn.Execute(updateSQL) This statement executes fine when i test it in access but here, it returns the above error. I have checked that all the fields are the same as that in the database and the textboxes match aswell. Neither txtcode or txtDesc are bound to any component. What could the problem be? if you need any more information, please let me know, any help would be greatly appreciated!!
-
Dim updateSQL As String updateSQL = "Update Product Set " & _ " Description = '" & txtDesc.text & "', " & _ :confused:" Where Code = '" & txtCode.Text & "'" Set RS = Conn.Execute(updateSQL) This statement executes fine when i test it in access but here, it returns the above error. I have checked that all the fields are the same as that in the database and the textboxes match aswell. Neither txtcode or txtDesc are bound to any component. What could the problem be? if you need any more information, please let me know, any help would be greatly appreciated!!