>Am converting a fp2.6 system to vfp9 and part of the effort is converting the tables. One table has a memo field that needs to be converted.
>The routine I'm using creates a cursor and loads the old table into it. The field that I load the memo field into is C(254).
>When it's loaded I open the new empty table and do the following:
>select dummy
>go top
>for i = 1 to lntotcnt
> select client
> scatter memvar
> cname_id = dummy.xname_id
> etc . . etc
> mNotes = dummy.xNotes && this doesn't work! there is data in dummy.xNotes.
> append blank
> gather memvar
> skip in dummy
>endfor
>
>What code can I use to copy the dummy.xNotes c(254) data into the mNotes memo field?
>All help appreciated.
>Bill
You may just use Replace, e.g.
Replace mynewmemofield with myoldcharvalue in mytable.
Btw, using Scan is better than For...Endfor
Also, your code would work, though it doesn't look nice, if you use
Scatter/Gather
memo memvar
Edward Pikman
Independent Consultant