Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized View dialog problem
Message
From
07/06/2001 12:53:12
 
 
To
07/06/2001 12:41:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00516426
Message ID:
00516458
Views:
19
>>>Can someone give me the proper way to input a date into the built in dialog box that prompts for input when trying to browse a view in design mode? I have tried various combos like {^2002-01-01} or CTOD("01/01/2001") etc. and all I get are operator/operand mismatches and ambiguous date complaints no matter what I try. If I set my input variable from the Command Window with any of the above forms it flies like a champ. What does this dialog box want? Thanks.
>>
>>Jim,
>>Combos ? If so dtoc() since combo values are always char type.
>>If combos mean combinations < g > then make sure your parameter is date type. {^2000/1/1} would work).
>>Cetin
>
>Hi Cetin,
>
>Yes, I meant combinations. From my comments above, I have tried the {^2001-1-1} format and I get the "Ambiguous date/datetime constant" error. That is what is driving me crazy! {^2001-01-01} or {^2001/01/01} or any other variant I can think of gives me the same error. What am I missing here?

BTW, I'm using VFP6 SP5 and
?set("STRICTDATE") = 1
?set("DATE") = AMERICAN
?set("CENTURY") = ON

if it has any relevance.
Previous
Reply
Map
View

Click here to load this message in the networking platform