Consulta de Moviments magatzem
En el formulari Cons_Movmag botó btnOK Mètode OnClick cal treura la ordenacio per data de moviment (linea amb vermell)
** Executa select per buscar existencia que hi ha a una data
lcSQL = [Select sum(q_entrada) as ent, sum(q_sortida) as sor ] + ;
[ from ges_moviments where ] + ;
[ empresa = ?gpEmpresa and data_movim<?M_DataFi ]
lcsql = lcsql + lcWMag
IF !EMPTY(lcArt)
lcSQL = lcSQL + [ and article=?lcArt ]
endif
lcLot = ALLTRIM(ThisForm.txtLot.value)
IF !EMPTY(lcLot)
lcSQL = lcSQL + [ and nserie_lot = ?lcLot ]
endif
lcSQL = lcSQL + [ group by article ]
** lcSQL = lcSQL + [ order by data_movim ] <------------------ asteriscar aquesta linea !!!!!!!!!!!!!!!!