>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!
>>
>>ArnoldWords are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
Off
There is no place like [::1]