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:
01214610
Views:
12
SCATTER MEMVAR MEMO/GATHER MEMVAR MEMO.

>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
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform