"Through the Query of time"
Posted on 2000-02-24
------Querys with time fields-------
Assume I have a table like this:
MYTABLE With fields: Code (Integer Type), Time1 and Time2 (of Type TTime)
and I want to do a query like this:
SELECT * FROM mytable
WHERE time1 <= 12:00:00
But the program returns:
"Token not found.
Line Number 2"
Well, as you may have noticed I want to know how to do queries in time fields.
I tried removing the spaces in te WHERE clause, like this:
but then it returns:
"Invalid use of keyword. Token: time1<=12. Line number 2"