delphinsl wrote:При выполнении данного SQL запроса, появляется вот такая ошибка. Началось с версии 3.3
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.trud,
vedisp.cashstage,
vedisp.NDS,
vedisp.vidcash,
Glisp.nameGi,
Soisp.nameisp,
vedisp.Zakl_OC,
vedisp.Zakl_TFC,
vedisp.udost,
(case when vedisp.otmstage=1 then 'да' else 'нет' end),
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 strftime('%m.%Y',vedisp.endstage)= strftime('%m.%Y',{DateTimePicker1}) and vedisp.otmstage='0'
order by dateend
может в моем коде что то вам поможет
select
id,
strftime('%d.%m.%Y',shc_data) as shc_data,
shc_agent,
(SELECT IFNULL(st.stname, '') FROM st WHERE st.id=id_st),
(SELECT IFNULL(st.stcode,'') FROM st WHERE st.id=id_st),
(SELECT cemtype.cemtypeName FROM cemtype WHERE cemtype.id=id_cemtype),
(SELECT pack.pacName FROM pack WHERE pack.id=id_pack),
shc_tonn,
shc_cost,
shc_total,
shc_contact,
shc_fact1,
shc_fact2,
shc_fact3,
shc_fact4,
shc_sap,
shc_broker,
shc_add,
(case when shc_an = 1 then 'Да' else 'Нет' end)
from shc_data
WHERE ( Date(shc_data) >= Date({A1}) ) AND ( Date(shc_data) <= Date({A2}) )
UNION ALL
select
id,
strftime('%d.%m.%Y',kaspi_data) as kaspi_data,
kaspi_agent,
(SELECT IFNULL(st.stname, '') FROM st WHERE st.id=id_st),
(SELECT IFNULL(st.stcode,'') FROM st WHERE st.id=id_st),
(SELECT cemtype_kaspi.cemtypeName_kapsi FROM cemtype_kaspi WHERE cemtype_kaspi.id=id_cemtype_kaspi),
(SELECT pack.pacName FROM pack WHERE pack.id=id_pack),
kaspi_tonn,
kaspi_cost,
kaspi_total,
kaspi_contract,
kaspi_fact1,
kaspi_fact2,
kaspi_fact3,
kaspi_fact4,
kaspi_sap,
kaspi_broker,
kaspi_add,
(case when kaspi_an = 1 then 'Да' else 'Нет' end)
from kaspi_data
WHERE ( Date(kaspi_data) >= Date({A1}) ) AND ( Date(kaspi_data) <= Date({A2}) )
UNION ALL
select
id,
strftime('%d.%m.%Y',bcc_data) as bcc_data,
bcc_agent,
(SELECT IFNULL(st.stname, '') FROM st WHERE st.id=id_st),
(SELECT IFNULL(st.stcode,'') FROM st WHERE st.id=id_st),
(SELECT cemtypebcc.cemtypeName_bcc FROM cemtypebcc WHERE cemtypebcc.id=id_cemtypebcc),
(SELECT pack.pacName FROM pack WHERE pack.id=id_pack),
bcc_tonn,
bcc_cost,
bcc_total,
bcc_contract,
bcc_fact1,
bcc_fact2,
bcc_fact3,
bcc_fact4,
bcc_sap,
bcc_broker,
bcc_add,
(case when bcc_an = 1 then 'Да' else 'Нет' end)
from bcc_data
WHERE ( Date(bcc_data) >= Date({A1}) ) AND ( Date(bcc_data) <= Date({A2}) )
с Ув. Андрей