Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pulling Records In A Scheduler
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Pulling Records In A Scheduler
Miscellaneous
Thread ID:
01308890
Message ID:
01308890
Views:
58
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
Next
Reply
Map
View

Click here to load this message in the networking platform