Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I programatically access field data?
Message
De
19/03/2004 12:19:57
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00887833
Message ID:
00887976
Vues:
6
Take a look at Afields() in the help...I think this will do the trick.

>I have a lookup table with 27 records and 71 fields per record.
>65 of those fields are MEMO fields containing static text.
>I need to update each memo field to remove junk (carridge returns and line feeds) from the end of each memo.
>
>Is there a way I can access the content of the memo fields by number instead of name?
>I'd like to do something like....
>
>
>SCAN
> FOR I = 6 TO 71
>  REPLACE FIELD(I) WITH CleanMemo(Field(I))
> ENDFOR
>ENDSCAN
>
>
>So if Field(6) contains
>
>"Mary had a little lamb.$%$%"
>
>where $ represents CHR(10)
>and % represents CHR(13)
>
>CleanMemo(Field(6)) would return
>
>"Mary had a little lamb."
>
>
>All I can get so far if that Field(I) returns the field name, but I can't get the field contents.
>
>Rick
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform