how do i use update command in vb??
I need to make changes in the database from vb form,the changes made in the text box should be made in the database as well,this is the code i am using
Con.Execute "update Details set PS_No=" & Trim(txtPSNo.Text) & " and NAME=" & txtName.Text & " and DT_OF_BTH=" & txtDOB.Text & " and DT_OF_JOING=" & txtDOJ.Text & " and SALARY_ACC=" & txtAccountNo.Text & " and REMBSMNT_ACC=" & txtRmbr.Text & " where PS_No=" & Trim(txtPSNo.Text) & ""
the err is "Attribute cannot be set now"
This is the code for delete command i m using
Con.Execute "delete from Details where PS_No=" & Trim(txtPSNo.Text) & ""
This is deleting the data,but is giving me an err msg as well
The err is "Syntax err operator missing"