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:
00599424
Views:
14
This message has been marked as a message which has helped to the initial question of the thread.
< snip >
>
lcFilter = [NOT EMPTY( CHRTRAN( Amenities, &cValidAmenities, " "))]
>
>
>Can I put this modified expression in a table? cValidAmenities would be a global string.

I think you can but you'll have to modify it a little bit
lcFilter = [NOT EMPTY( CHRTRAN( Amenities, "&cValidAmenities", ""))]
>Lookups tables rarely get updated (almost never), so instead of using cValidAmenities string I can explicitly put the values.

It's dangerous because at some time it could change and nobody would remember that the filter expression has to be changed also.

>
< snip >
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform