Topic: Отчет (SQL)
Написал такой скрипт:
select
BDog.num_gk,
strftime('%d.%m.%Y',bdog.date_gk),
BDog.shifr,
BDog.nameGK,
vedisp.numstage,
vedisp.namestage,
vedisp.ONTD,
strftime('%d.%m.%Y',vedisp.startstage),
strftime('%d.%m.%Y',vedisp.endstage)as dateend,
vedisp.vidcash,
BDog.prim,
GZak.ZakName,
Glisp.namegi,
(case when vedisp.otmstage = 1 then 'Да' else 'Нет' end),
vedisp.id_bdog,
bdog.id,
bdog.id_GLisp,
BDog.id_GZak
from vedisp, bdog, glisp, gzak
where vedisp.id_bdog=bdog.id and GLisp.id=bdog.id_Glisp and GZak.id=BDog.id_GZak
and (glisp.id={combobox4} or {combobox4}=-1)
and (strftime('%m.%Y',vedisp.endstage)=strftime('%m.%Y',{DateTimePicker2}) or strftime('%m.%Y',vedisp.endstage)=strftime('%m.%Y',{DateTimePicker1}))
and vedisp.otmstage='0'
Union all
select
SoispDog.num_dog,
strftime('%d.%m.%Y',SoispDog.date_dog),
soispdog.shifr_dog,
SoispDog.name_dog,
vedisp.numstage,
vedisp.namestage,
vedisp.ONTD,
strftime('%d.%m.%Y',vedisp.startstage),
strftime('%d.%m.%Y',vedisp.endstage)as dateend,
vedisp.vidcash,
SoispDog.prim_dog,
Glisp.nameGi,
Soisp.nameisp,
(case when vedisp.otmstage = 1 then 'да' else 'нет' end),
VedIsp.id_SoispDog,
soispdog.id,
soispdog.id_GLisp,
soispdog.id_soisp
from vedisp, soispdog, Glisp, soisp
where vedisp.id_soispdog=soispdog.id and soispdog.id_soisp=soisp.id and soispdog.id_Glisp=GLisp.id
and ((case when {ComboBox1}=-1 then 1=1 else {ComboBox1}=soisp.id end) or (case when {ComboBox4}=-1 then 1=1 else {ComboBox4}=glisp.id end))
and (strftime('%m.%Y',vedisp.endstage)= strftime('%m.%Y',{DateTimePicker1}) or strftime('%m.%Y',vedisp.endstage)= strftime('%m.%Y',{DateTimePicker2}))
and vedisp.otmstage='0'
order by dateend
Свойство combobox мултиселект включено. Возможно каким-то способом передать ID выбранной записи combobox в скрипт?