select ... cast("" as M) as Missing, ... into cursor cur1But I get the error message: "Operation is invalid for a Memo, Blob, General or Picture field.". If I remove this one field, everything works fine.
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 READWRITEThe debugger shows me that lcExtra1 and lcExtra2 are empty strings; I used the variables to conditionally add additional conditions.