Information générale
Catégorie:
Codage, syntaxe et commandes
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement