>SELECT; >" " as MatProblem,; >CAST("" AS M) AS Missing,; >Curx.Line,Curx.priority,Curx.Customer,; >Curx.CUT,Curx.Desc_Cut,Curx.STYLE,Curx.Desc_Style,Curx.DUEDATE,; >Curx.total,Curx.totstd,Curx.cutdate,; >00000.00 as timetictot,; >00000.00 as timetic,; >00000.00 as balance,; >00000.00 as diasf,; >0000000.00 as horasf,; >DATE() as fec,; >00 as horad; >FROM (; > SELECT Cut.Line, priority, bname as Customer, cut.CUT, cut.description as Desc_Cut, style.STYLE,; > style.description as Desc_Style, DUEDATE, cut.total, totstd,cutdate; > FROM cut, cutdtl, style, customer; > WHERE cut.custcode = customer.code; > AND cut.cut = cutdtl.cut; > AND cutdtl.style = style.style; > AND duedate >= thisform.text1.Value AND duedate <= thisform.text2.Value; > AND EMPTY(dtcompl); > AND cut.total > thisform.text10.Value; > &lcExtra1 &lcExtra2; > DISTINCT) as curx; > INTO CURSOR cur1 READWRITE; > ORDER BY Priority, DueDate >>