Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Capability not supported - Today() Function
When I ran the query below I got an error message: Capability Not Supported. SELECT COUNT( CardNo ) FROM "Clients.DB" Clients WHERE ConExpiry >= Today()- JonnyBee
- Thread
- Replies: 2
- Forum: Corel: Paradox
-
SYSDATE in SQL
I am trying to compare the sysdate to a field value. The SQL I have is as follows: SELECT COUNT(CardNo) FROM "Clients.DB" Clients WHERE ConExpiry >= Sysutils.date; This doesn't work. What do I put in place of Sysutils.date?- JonnyBee
- Thread
- Replies: 1
- Forum: Embarcadero: Delphi
