Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized views
Message
From
11/11/1999 23:29:32
 
 
To
11/11/1999 09:09:36
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00289994
Message ID:
00290478
Views:
13
>Hi Porter,
>
>WHERE ?m.Key OR ?m.SelectAll
>If SelectAll is .t., you get all the records; if false, only the matching keys.
>You can use as many parameters as you need.
>Charlie
>
>>I am trying to select either specific records or all records from a parameterized view. In the case of a character field, if the view parameter = "", all of the records are selected. However, if the view parameter is based on an integer field, is there a way to select all the records, when using the equals clause. (or should I try a different way)?
>>Thanks in advance
>>
>>Porter Bailey


Thanks Craig and Charlie. Both of these solutions do the job quite well. The between filter I had suspected. It hadn't occurred to me to use more than one parameter though, and that solution works great too.
Thanks a lot.

Porter Bailey
Previous
Reply
Map
View

Click here to load this message in the networking platform