>I'm trying to do that little trick to get a new memo field in a SQL, but can't quite recall how to do it. This is what I have, which returns an error on the SQL:
>

>CREATE CURSOR GetMemo (Action M)
>
>SELECT *, ;
>	SPACE(254) AS Description, ;
>	GetMemo.Action AS Action ;
>	FROM X12_Response ;
>	JOIN GetMemo ;
>	INTO CURSOR crsWorkList ;
>	READWRITE
>

Hilmar gave the solution, but if you ever need to do this in an older version.........

There are two problems with what you tried.

I'm pretty sure you got an error message because JOIN requires a condition. You don't really need the JOIN. You can include both tables in the FROM clause.

When you correct that, however, you will have an empty resultset because there are no records in GetMemo. You could either do a LEFT JOIN (each Action field would be NULL) or append a blank record into GetMemo.

CREATE CURSOR GetMemo (Action M)
APPEND BLANK

SELECT *, ;
	SPACE(254) AS Description, ;
	GetMemo.Action AS Action ;
	FROM X12_Response,
	JOIN GetMemo ON .T.;
	INTO CURSOR crsWorkList ;
	READWRITE


or

SELECT *, ;
	SPACE(254) AS Description, ;
	GetMemo.Action AS Action ;
	FROM X12_Response, GetMemo ;
	INTO CURSOR crsWorkList ;
	READWRITE

(You will not be shocked to learn that I know this because I had the same problem back in September and Sergey provided the solution.)