Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parametrized local view requery problem
Message
 
To
06/05/2001 11:27:29
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00503997
Message ID:
00504005
Views:
19
This message has been marked as the solution to the initial question of the thread.
Hi Christian,

SET STRICTDATE TO 0

or send the parameter DATETIME() instead of DATE().

HTH.

>HI,
>I try to requery a parametrized local view. The parameter is date datatype. When I issue : =REQUERY("MyView"), I receive an error message :
>" Ambiguous date/datetime constant. Use the format:
> {^yyyy-mm-dd[,][hh[:mm[:ss]] [a|p]]}"
>
>I even receive this message when I use DATE() as parameter. How should I format the parameter to make it valid ?
>
>Thank you,
>Christian Cote
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN

If a vegetarian eats vegetables, what does a humanitarian eat?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform