General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only