Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I programatically access field data?
Message
From
19/03/2004 12:19:57
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00887833
Message ID:
00887976
Views:
5
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
Previous
Reply
Map
View

Click here to load this message in the networking platform