Topic: Multiselect Combobox в SQL запросе
SELECT
Zayvka.ZayvkaDateOplata,
Mat.MatName,
Zayvka.ZayvkaKol,
Zayvka.ZayvkaSumma
FROM Zayvka
LEFT OUTER JOIN Mat ON Mat.id=Zayvka.id_Mat LEFT OUTER JOIN Gruppa ON Gruppa.id=Mat.id_Gruppa LEFT OUTER JOIN MatMesto ON MatMesto.id=Mat.id_MatMesto LEFT OUTER JOIN Postavsik ON Postavsik.id=Zayvka.id_Postavsik
WHERE
(Zayvka.ZayvkaSumma > 0) AND
(CASE WHEN {DateTimePicker1} IS NOT NULL THEN date(ZayvkaDateOplata) >= date({DateTimePicker1}) ELSE 1=1 END) AND
(CASE WHEN {DateTimePicker2} IS NOT NULL THEN date(ZayvkaDateOplata) <= date({DateTimePicker2}) ELSE 1=1 END) AND
(CASE WHEN {ComboBox1} <> -1 THEN Mat.id_Gruppa = {ComboBox1} ELSE 1=1 END) AND
(CASE WHEN {ComboBox2} <> -1 THEN Mat.id_MatMesto = {ComboBox2} ELSE 1=1 END) AND
(CASE WHEN {ComboBox3} <> -1 THEN Zayvka.id_Postavsik = {ComboBox3} ELSE 1=1 END)
ORDER BY Zayvka.ZayvkaDateOplata
Этот SQL запрос работает.
При использовании Multiselect в Combobox работать перестаёт.
Вернее он не воспринимает Combobox с Multiselect.
Помогите доработать!
Спасибо,
Пётр