• Registered: 2016-04-25
  • Posts: 14

Topic: Подскажите по отчетам.

как написать код чтобы выдавалось значение с формы из ComboBox
В поиске ComboBox не участвует

SELECT
baza.record_count,
baza.data,
baza.datavipolneniya,
adres.adres,
baza.kvartira,
baza.fio,
baza.kontakt,
tip.tip,
baza.soderjanie,
ispolnitel.ispolnitel,
baza.vremya,
baza.primichanie,
platnaya.platnaya,

strftime('%d.%m.%Y',{dtFrom}) as datefrom,
strftime('%d.%m.%Y',{dtTo}) as dateto


FROM baza

LEFT OUTER JOIN adres ON adres.id=baza.id_adres
LEFT OUTER JOIN tip ON tip.id=baza.id_tip
LEFT OUTER JOIN ispolnitel ON ispolnitel.id=baza.id_ispolnitel
LEFT OUTER JOIN platnaya ON platnaya.id=baza.id_platnaya
WHERE(baza.data  >={dtFrom})and(baza.data <={dtTo})

Post's attachments

Attachment icon Безымянный00.JPG 9.03 kb, 230 downloads since 2016-04-29 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Подскажите по отчетам.

Можно так

SELECT
 baza.record_count,
 (SELECT fieldname FROM tablename WHERE tablename.id={ComboBox}) as ComboBoxValue,
 baza.data,
 baza.datavipolneniya,
 ..........
Dmitry.