Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery a param. view with date parameters
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Requery a param. view with date parameters
Miscellaneous
Thread ID:
00674575
Message ID:
00674575
Views:
49
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?
Next
Reply
Map
View

Click here to load this message in the networking platform