Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter incorrect coded values
Message
 
 
To
31/12/2001 11:03:35
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00599378
Message ID:
00599387
Views:
10
>>One more complication for Amenities field - this field is 10 char long and it's a concatenation of codes, e.g. ABCUD, where each letter is a code. How would we filter those contain incorrect codes?
>
>For this one, I don't know a simpler alternative than to use a FOR loop.
>
>
>* Function for validation)
>local i
>for i = 1 to len(amenities)
>  if not substr(Amenities, i, 1) $ "ABCDE" && or other valid codes
>    return .F.
>  endif
>next
>
>
>Hilmar.

No, I need one SET FILTER TO command, so loop would not work. I guess, I can put all codes in a thisform.cAmenities string, then something using chrtran. However, even this idea has some problems, because Set Filter is another form, which would not now about main form...
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