Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pulling Records In A Scheduler
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Pulling Records In A Scheduler
Divers
Thread ID:
01308890
Message ID:
01308890
Vues:
57
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform