>>>>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
>
>there is no way to do it directly. The trick is to create another, dummy table with only a memo field in it, and join the tables in a select.


Ahhh...Gotcha...now David's post makes perfect sense to me. Thanks to both of you...this saved me lots of time!