Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parametrized view based on logical field
Message
 
 
To
19/10/2004 12:16:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00952678
Message ID:
00952695
Views:
9
This message has been marked as the solution to the initial question of the thread.
>hi!
>I have a logical field project.terminated
>
>I would like to create a parametrized view that will permit me
>1. select only terminated projets.
>2. select only not terminated projects.
>3. select all projects.
>
>thanks in advance,
>Nir.

Your view filter clause should look like:

WHERE INLIST(Project.Terminated, ?lParm1, ?lParm2)

When you need only terminated projects, set lParm1 and lParm2 to true. When you need not terminated projects, set both to false. When you need all, set one to true and the other to false.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform