Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pulling Records In A Scheduler
Message
De
08/04/2008 14:11:44
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01308890
Message ID:
01309107
Vues:
10
What about this? (just off the top of my head -- not sure if this will work the way you want)
ltNow = DATETIME()
lnYr = YEAR(m.ltNow)
lnMo = MONTH(m.ltNow)
lnDy = DAY(m.ltNow)
lnDiff = 60    && Adjust to whatever you need
SELECT att_pk;
	FROM AutoTask;
	WHERE (m.ltNow-DATETIME(m.lnYr,m.lnMo,m.lnDy,att_hour,att_min))<=m.lnDiff;
	INTO CURSOR crsrAutoTasks
(the above code will need a few tweaks to work correctly for cases where the hour and date are close to the end of the day)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform