[RESOLVED] [2005] Unable to delete record
VB Code:
MyConnection.Open()
Dim delStr As String = "DELETE FROM PATIENTS WHERE PatientID='" & tboxPatientID.Text & "'"
MyCommand = New OleDbCommand(delStr, MyConnection)
MyCommand.ExecuteNonQuery()
MyConnection.Close()
I am using this as my code for my delete button.PatientID was an autonumber field in my access database and apparently the application was giving me a "Data type mismatch in criteria expression" exception.When I replaced the string as " DELETE FROM PATIENTS WHERE LastName='" & tboxLastName.Text & "'", the code was doing fine, but of course it will delete all records with the same lastName.What could be a possible solution here?thanks...
Re: [2005] Unable to delete record
u need to check datatype of patient_id if its not of string type then u need to convert it like wise
suppose if its integer then need to some thing like this
Dim delStr As String = "DELETE FROM PATIENTS WHERE PatientID=" & val(tboxPatientID.Text) & ""
Re: [2005] Unable to delete record
thanks man for your promptness....