SQLite INNER JOIN Issue

[Jay_Madren]

@440036:@Azi Pam

Thanks for response. I’ve added an error check and I do get a message box indicating an error has occurred.

What is the error message?

@440036:@Azi Pam

The Parameter for the method is ‘patientID As String’,

But what is the data type of the Patient.ID column in the database? Even though SQLite is loosely typed, how you format parameters in a SQL statement can make a difference. If it is defined as TEXT, then you need to enclose it in quotes in the SQL statement.

@440036:@Azi Pam

how would it be best to procced with running the SELECT without the prepared statement? Would that not prevent the use of Bind to determine the ‘WHERE Patient.ID=?’ ?

Issue this instead:

Dim rs As RecordSet = Session.db.SQLSelect("SELECT Patient.ID, Patient.Forename, Patient.Surname, Patient.DateOfBirth, Patient.Address, Patient.Allergies, Patient.Notes, Patient.Type, Doctor.DocID, Doctor.DoctorName, Doctor.DoctorAddress FROM Patient INNER JOIN Doctor ON Patient.DoctorID = Doctor.DocID WHERE Patient.ID='" + patientID + "'")

or ...WHERE Patient.ID=" + Str(patientID)) if patientID is a number data type