>Hi,
>
>I am trying, and failing, to include a memo field in a UNIONed SQL SELECT. I've pared the statement down to the following:
>
>

>SELECT app_activitycomments ;
>	FROM appointments ;
>	INTO CURSOR c_Temp ;
>	WHERE !app_activity AND app_clientfk > 0 AND app_GroupnameFK=0 ;
>	UNION ;
>		SELECT app_activitycomments ;
>			FROM appointments;
>			WHERE !app_activity AND app_clientfk=0 ;
>			UNION ;
>				SELECT app_activitycomments ;
>					FROM appointments ;
>					WHERE app_activity
>

>
>and i get the error:
>
>"Operation is invalid for a Memo, Blob, General or Picture field"
>
>I can't have a memo in a UNION SQL SELECT statement?
>
>TIA, j

Jill,

With the UNION ALL you may end up with duplicate records

The statement above can be rewritten without a UNION

SELECT app_activitycomments ;
    FROM appointments ;
    INTO CURSOR c_Temp ;
    WHERE  ( app_activity ) ;
        or ( app_clientfk > 0 AND app_GroupnameFK=0 ) ;
        or ( app_clientfk=0 )

&& if app_clientfk cannot be negative

SELECT app_activitycomments ;
    FROM appointments ;
    INTO CURSOR c_Temp ;
    WHERE  ( app_activity ) ;
        or ( app_clientfk = 0 ) ;
        or ( app_GroupnameFK=0 )