Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Usability of date syntax in SQL
Message
 
To
10/04/2003 00:50:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00775883
Message ID:
00775921
Views:
14
You could also try this:
lcSetDate=Set([date])
lcSetMark=Set([mark])
SET DATE  TO  YMD
SET MARK TO "-"

lcSQL=[SELECT Numero FROM News WHERE Year={d '] + Alltrim(Dtoc(vuData)) + ['}]

Set Date To (lcSetDate)
Set Mark To (lcSetMark)
Venelina Jordanova

Outsourcing IT Services Ltd.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform