>select ... cast("" as M) as Missing, ... > into cursor cur1 >>
>SELECT SPACE(1) as MatProblem, CAST("" AS M) AS Missing, 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,; > 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 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; > ORDER BY Priority, DueDate; > DISTINCT; > INTO CURSOR cur1 READWRITE >>