Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select with date in the where-part in ADO
Message
From
26/09/2001 08:59:23
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Select with date in the where-part in ADO
Miscellaneous
Thread ID:
00560904
Message ID:
00560904
Views:
74
Hi,
when I try to select with a numeric or character comparison in the where-part, it functions OK.
But how can I use a time/date comparison in the where-part?
I use this query and put it in the sourceproperty of an ADO command object:
SELECT N_ID,C_NAME,C_PLATE,D_STARTDATE, .... FROM database WHERE D_STARTDATE = CTOD('09-09-2001')
I understand that the CTOD command doesn't exist where (in ADO) the query runs, but I really need to select by date...

TIA ET
Next
Reply
Map
View

Click here to load this message in the networking platform