I have an AutoTask table with Hours and Minutes fields. The records can have times within 1 minute of each other.
How do I pull only the records that should be processed at that particular moment?
I tried this, but it isn't quite right:
SELECT att_pk;
FROM AutoTask;
WHERE (HOUR(DATETIME()) = att_hour AND;
MINUTE(DATETIME()) <= att_min);
INTO CURSOR crsrAutoTasks
Thanks
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people