Delete Record From Multiple Tables witn Same ID in MySQL using VB.NET

I use listview and button the scenario is when i choose data in the listview it will delete all the record with the same id in many tables and i use ODBC

Dim cmd As New Odbc.OdbcCommand("DELETE FROM patientpersonal,patientmedical,patientdental WHERE patientpersonal.'" & dpatientid & "' = patientmedical.'" & dpatientid & "' AND patientpersonal.'" & dpatientid & "' = patientdental.'" & dpatientid & "' ", con)
Call DisplayDentalPatient()
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!