Zoran,

Replace your 1=1 with a simple .T.. ::)

Agnes
>Arnold,
>
>You could try something like :
>
>

>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

Words 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]