Member Avatar for aalqa

hello
I want to deleter record from my table in database but there is error which is Data type mismatch in criteria expression ,any one has any idea can tell me thank you.

  • 2 Contributors
  • 2 Replies
  • 91 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by aalqa
Member Avatar for ArtistScope

You should post the code for us to see, but I would guess that because you are deleting a row that is identified by ID that you may only have to change the parenthesis, so instead of using

where ID = "' & strID & '"

try using

where ID = ' & strID & '
Edited by ArtistScope because: n/a
Member Avatar for aalqa

Thank you , I get the solution and the solution is near to your solution

WHERE PatientId='" & pid & "'",conn
  %>

the solution was

"SELECT * FROM Patient WHERE PatientId=" & pid,conn
  %>
Edited by aalqa because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.