08 Fev 2019 17:43
select
c.codmun, c.carrega, c.data , sum(c.pesobal) ,sum(c.totkilos), ca.placa, m.nomemun, mo.nome
from
Lan_2018 c , carrega ca , motori mo , cadmun m
where
c.data >= '2018-07-01' and c.data <= '2018-07-31'
and c.codmun >= '0062' and c.codmun <= '0062'
and c.carrega = ca.codigo
and ca.codmoto = mo.codigo
and ca.codmun = m.codmun
group by
c.codmun, c.carrega ,c.data, ca.placa, m.nomemun, mo.nome;
18 Abr 2019 14:02
// 1 2 3 4 nomemun 5
xcampos:="tab_uso.codigo, tab_uso.nome,tab_uso.fantasia, '' , tab_uso.codmun"
Str:="SELECT first "+str(browse_qtreg,2)+" skip("+str(browse_qtPula,5)+") "+xcampos+ " from cadfor tab_uso ;"
// 1 2 3 4 5
//xcampos:="tab_uso.codigo, tab_uso.nome,tab_uso.fantasia, m.nomemun , tab_uso.codmun"
Str:="SELECT first "+str(browse_qtreg,2)+" skip("+str(browse_qtPula,5)+") "+xcampos+ " from cadfor tab_uso ";
+" LEFT JOIN cadMun m on m.codmun = tab_uso.codmun ;"
18 Abr 2019 14:03
19 Abr 2019 18:58
07 Ago 2019 20:52
09 Ago 2019 18:38