Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
About the DATE format
Message
 
To
18/06/1999 13:24:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00231431
Message ID:
00231508
Views:
20
Power,

In whatever method you are opening the view put code like this;

* Whatever method
LOCAL ldStart, ldEnd
ldStart = Thisform.TxtStartDate.Value
ldEnd = Thisform.txtEndDate.Value
* Then either
USE TheView
* OR
Requery("TheView")

In the view desinger set up your filter as;

DateField >= ?ldStart AND
DateField <= ?ldEnd

The ? will make those variable names view parameters and VFP will use the variables to resolve the filter when you opne or requery the view.
Previous
Reply
Map
View

Click here to load this message in the networking platform