Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter incorrect coded values
Message
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00599378
Message ID:
00599409
Views:
11
< snip >
>>
>>You can gather all valid codes in a variable, say lcValidAmenities and than something like
lcFilter = [NOT EMPTY( CHRTRAN( Amenities, "] + lcValidAmenities + [", "] + ;
>>    SPACE( LEN( lcValidAmenities)) + ["))]
>>SET FILTER TO &lcFilter
>
>Would
>
lcFilter = [NOT EMPTY( CHRTRAN( Amenities, "] + lcValidAmenities + [", " "))]
work?
>
>BTW, the problem is more complicated, because SetFilter form is different, than main form, and Filter defitions are stored in a table.

Yes, it would. Can you change SetFilter form to allow build filter expression dynamicaly? Otherwise you will have to update the record for this filter in the table with filter exoresions every time the list of valid Amenities codes chages.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform