Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filtering using certain conditions
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Filtering using certain conditions
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01075616
Message ID:
01075616
Views:
51
I am trying to set a filter on a table with 4 variables which work great if all 4 variables have information. How can I set this up if say only 2 out of the 4 have information. My code is currently:
SELECT planrep
SET FILTER TO INLIST(planrep.dept,&lcdept) AND INLIST(planrep.factory,&lcfactory) AND INLIST(planrep.country,&lccountry) AND INLIST(planrep.season,&lcseason)
There may be a time that I only want to filter by just lcseason.
Neil Lewis
IT R&D Manager
Velmore Ltd
Next
Reply
Map
View

Click here to load this message in the networking platform