copy contents of memo field to another field

[choppysuey]

Can anyone tell me what the easiest way is to copy the contents of a character field to a memo field in the same table? I was thinking about copying the contents of the character field into a string variable and then use a replace command to stuff it into the memo field. Seems like it's the long way of doing it. I'm using VFP 6.

 

[danceman]

replace all memofiled with textfield Attitude is Everything

 

[Mike Gagnon]

choppysuey

1. If you want to add the info to the memo field:

UPDATE myTable SET myMemoField = myMemoField+myCharField

And if you want to just copy

UPDATE myTable SET myMemoField = myCharField

P.S. Carefull this will do the whole table.


Mike Gagnon

 

[danceman]

the posting I posted assumed that you wanted to do a replace of all the records.

if only one record is to be done you cna do as mgagnon posted or remove the all from replace

replace memofiled with textfield && at the present record

replace memofiled with textfield while condiction && will replace all records that meet the condiction Attitude is Everything

 

[Mike Gagnon]

Danceman

if only one record is to be done you cna do as mgagnon posted

This does all records as well. Mike Gagnon

 

[danceman]

mgagnon
yes, you are correct. i read more into it then was posted, so use to seing condictions on an update. Attitude is Everything

 

[choppysuey]

Thanks for the posts. I wanted to do the replace on all records. The commands posted did what I wanted. One day I'll get the hang of VFP. Problem is that I don't get to work with it often enough to know the language. Thanks once again for the help.