Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parametrized local view requery problem
Message
 
À
06/05/2001 11:27:29
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Québec, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00503997
Message ID:
00504005
Vues:
18
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform