>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only