>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