Hi. I want to add an initially empty memo field to a cursor I create, and I thought the following syntax would be appropriate:

select ... cast("" as M) as Missing, ...
  into cursor cur1

But 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.

No field is referenced by number in an ORDER BY or GROUP BY clause - I thought at first that that might be the problem.

Any ideas?

For more details, I copy the entire command below.

TIA,

Hilmar.


The entire command is as follows:

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 

The debugger shows me that lcExtra1 and lcExtra2 are empty strings; I used the variables to conditionally add additional conditions.