Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to copy Memo field into vfp table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01214602
Message ID:
01214604
Vues:
7
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform