Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to find first non-vacation day before given date
Message
De
06/02/2006 14:32:28
 
 
À
03/02/2006 19:25:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01093556
Message ID:
01094060
Vues:
23
>* IF dstart is not nullable this is better
>SELECT NVL(MAX(T1.dend)+1,date(1960,1,1)) dFreeMaxFirst ;
> FROM vacation T1 ;
> WHERE dend < m.dbefore;
> AND dend + 1 NOT IN (SELECT dstart FROM vacation);
> INTO CURSOR result

Fabio, thank you. I can assume that dstart is NOT NULL
I tried code
CREATE CURSOR vacation  (dstart D,dend D)
INSERT INTO vacation  VALUES (DATE()+3,DATE()+5)

dbefore=DATE()
SELECT NVL(MAX(T1.dend)+1,date(1960,1,1)) dFreeMaxFirst ;
	FROM vacation T1 ;
	WHERE dend < m.dbefore;
		AND dend + 1 NOT IN (SELECT dstart FROM vacation);
		 INTO CURSOR result
? dFreeMaxFirst
Currect result is DATE()-1 but this code returs empty cursor.


Also

CREATE CURSOR vacation (dstart D,dend D)
INSERT INTO vacation VALUES (DATE()-3,DATE()+5)

returns empty cursor but correct result is date()-4
Andrus
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform