CREATE CURSOR Dummy ( MyMemo m )
APPEND BLANK
SELECT MyTable.*, Dummy.MyMemo;
FROM MyTable;
LEFT OUTER JOIN Dummy ON 1=1;
INTO CURSOR MyCursor
Cheers,
Zoran
>Hi Everybody
>
>Sometime I need to create an additional field in Select - SQL like this :
>
>Select FieldA,space(2) as FieldB from table readwrite
>
>where FieldB was created on the fly to put in some data manually as the cursor is readwriteable.
>Ok. My question is : how do I create a Memo field ???
>
>Thanks for your idea!
>
>Arnold