Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strictdate
Message
From
05/02/2001 18:12:20
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Strictdate
Miscellaneous
Thread ID:
00472725
Message ID:
00472725
Views:
65
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
Map
View

Click here to load this message in the networking platform