Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to copy Memo field into vfp table
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01214602
Message ID:
01214604
Views:
6
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform