Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
About the DATE format
Message
 
À
18/06/1999 13:24:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00231431
Message ID:
00231508
Vues:
21
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform