Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized View dialog problem
Message
From
07/06/2001 12:26:29
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
07/06/2001 12:12:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00516426
Message ID:
00516437
Views:
18
>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
Ç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