Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Parameters
Message
From
05/11/1997 11:26:51
 
 
To
05/11/1997 10:26:04
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00058352
Message ID:
00058379
Views:
35
>>>>>>I would like to have a view parameter that works like a logical, but uses a date field. I have a date field that is either empty or has some value. I would like to bring down the records that are either empty or have some value (regardless of what the value is). Is there some way I can set up a view paramter off of the date field to provide this functionality, or do I need to create another logical field?
>>>>>
>>>>>It's enough to use datefield equal {} (or NOT equal {}).
>>>>
>>>>How do you do that in a view parameter? You can't set the value of a view parameter to an expression.
>>>
>>>Why do you use 'expression'. You should just select datefield as 'Field Name' (View Designer: Selection Criteria tab), and type {} in 'Example'.
>>
>>That works if I always want the records with the date field being empty. I want the user to be able to choose (ie. parameterized) between empty and !empty.
>
>I think the simplest way is to use programmatic Select ... into Cursor, or you can use two views.

If you define the view in code you can put in the WHERE clause

empty(date) = glempty_or_not

and set glempty_or_not to .T. or .F. depending on what the user wants
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform