>>How do you create an empty memo field from an sql statement?
>>
>>for example:
>>
>>SELECT .T. as logical, space(10) as character ,;
>> {} as date, (need memo defined here for blank memo field) ;
>>FROM testing
>>
>>
>>Thanks :)
>>
>>John
>
>Say you have a table "A" which has stuff in it....
>CREATE CURSOR Dummy (Notes M)
>APPEND BLANK
>SELECT A.* , D.Notes ;
> WHERE ......
>
>Get the idea?
>HTH

Hi David,

I don't understand your post. All I want to do is create a memo field type column from an sql statement. I just need the syntax to create it for example, {} creates an empty date column, .F. creates a logical coulmn, space(#) creates character column, etc. I don't know what the syntax is to create an 'empty' memo field from an sql statement. Something this simple I should know, but I guess I've never done this before.

Thanks.

John