Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized View dialog problem
Message
From
07/06/2001 13:08:38
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
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:
00516476
Views:
21
This message has been marked as a message which has helped to the initial question of the thread.
>>>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?

Jim,
I'm surprised too. You're right in designer it sucks and no clue. I never use it and wasn't aware of it. It even denies date(1990,1,1).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform