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 !!!!!!!!!!!!!!!! |
Powered by
KBPublisher (Knowledge base software)