Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameters View with date format
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Parameters View with date format
Miscellaneous
Thread ID:
00232492
Message ID:
00232492
Views:
55
Hi Body

I make a parameters view on a date field. when i define the variable before i use the view all work fine but when i let popup the dialog box who ask value of the variable it always give me bad date format.

Do you know what i suppose to type to specify a date format?

_____________________________________________________________

CREATE SQL VIEW "TOTO" ;
AS SELECT Nofacture ;
FROM mp_data!Test ;
WHERE DateDu <= ?pdvDate1
____________________________________________________________

Thank's in Advance
Rock
Next
Reply
Map
View

Click here to load this message in the networking platform