Topic: Search SQL Query + ComboBox

SELECT
Agenda.id AS 'ID',
Agenda.Nume AS 'Nume',
Agenda.Prenume AS 'Prenume',
Agenda.Localitate AS 'Localitate',
Agenda.Numar AS 'Numar
Telefon',
Agenda.Email AS 'E-mail',
Telefon.numartelefon AS 'Telefon
FAX',
Grup.Numegrup AS 'Grup',
Agenda.Data AS 'Data
Programare',
Agenda.Activitati AS 'Activitati',
Agenda.Obs AS 'Observatii'
FROM
Agenda
LEFT OUTER JOIN Telefon ON Agenda.id=Telefon.id_Agenda
LEFT OUTER JOIN Grup ON Agenda.id_Grup=Grup.id
WHERE
(Agenda.Nume LIKE '%{Edit1}%'OR
Agenda.Prenume LIKE '%{Edit1}%' OR
Agenda.Localitate LIKE '%{Edit1}%' OR
Agenda.Numar LIKE '%{Edit1}%' OR
Agenda.Email LIKE '%{Edit1}%' OR
Agenda.Activitati LIKE '%{Edit1}%' OR
Agenda.Obs LIKE '%{Edit1}%' OR
Telefon.numartelefon LIKE '%{Edit1}%') AND Grup.Numegrup LIKE '{ComboBox1}'


Does not display any results, I tried to combine my knowledge AND the properties box office ComboBox, am I missing something really helped suggestion. Thanks a great day!

Re: Search SQL Query + ComboBox

{ComboBox1} return record identifier

Should be

AND Grup.id = {ComboBox1}
Dmitry.

3 (edited by einsteinf5 2015-03-19 18:49:17)

Re: Search SQL Query + ComboBox

I replaced according to your suggestion ... Thanks for saving my project.