>>Does anybody know how to do SQL SELECT statement that will move data from a character type field and move it into a memo field in the cursor?
>>
>>This is not trying to pull data from an existing memo field, but trying to create a new memo field that is populated with the data from the character field and will be massaged later on in the code.
>>
>>
>>CREATE CURSOR memotable (mfield M)
>>INSERT INTO memotable (mfield) VALUES ('')
>>SELECT mfield FROM memotable ;
>> UNION (SELECT cfield FROM chartable) ;
>> INTO CURSOR memocursor
>>
>>gives a UNION INCOMPATIABLE ERROR.
>>
>>Any suggestions?
>
>
Fred,
>Should it be strictly one SQL "select" ? Append from instead ? ie:
>
>create cursor memotable (mfield M)
>select cfields as mfield from chartable into cursor transfer nofilter
>select memotable
>append from dbf("transfer")
>
>Cetin
Cetin/Michael/Erik,
Thanks, guys. Doing it one step was not a requirement. I'll have to see if I can try your methods to merge it with other data from the SQL SELECT statements involved.
This is just for some "proof of concept" stuff were currently working on, so we may not even end up needing to do it this way. It's still kind of flexible, but the memo field seemed like the way to go. We just may implement this as a parent/child set of cursors for processing. Thanks again!
Happy New Year!