Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strictdate
Message
De
05/02/2001 18:12:20
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Strictdate
Divers
Thread ID:
00472725
Message ID:
00472725
Vues:
61
Someone showed me this and I wanted to pass it to the experts here and get an explanation

I've created a table in a database and want a view from it

SELECT *;
FROM rlp!rlp;
WHERE Rlp.d1 BETWEEN ?xx AND ?yy

When I try to USE the view I get prompted for XX and YY
If I enter {^2001-01-01} for XX and then {^2001-02-01} for YY the "Ambiguous Date" error message appears.

SET STRICTDATE TO 0 allows me to enter {1/1/2001} and (2/1/2001} without problems.

Is there something about the View Designer and parameterized date fields???

Thanks.........Rich
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform