General information
Category:
Coding, syntax & commands
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only