Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Requery a param. view with date parameters
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Requery a param. view with date parameters
Divers
Thread ID:
00674575
Message ID:
00674575
Vues:
48
Hi
I have a parameterized view with many parameters, that i requery throughout my program. When i want all the values for a specific parameter, i empty it and requery, and this works great. The only problem is that one of the parameters is of type DATE, and when i put in an empty date and requery, it does not show the records for all dates ( wich is what i want ), but i think that it brings me the results for the empty date itself ( i.e no records ). I cannot set it to .NULL. neither, since this will trigger an operand mismatch error...Is there a way ( some value for the date param. for instance ) that i don't know about to bring in the values for all dates in a requery?

TIA
Jaime
Why do programs stop working correctly as soon as you leave the Fox?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform