Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is wrong with this...
Message
 
 
À
02/03/2001 06:37:25
Jolene Dicks
Human Resources Development Canada
St. John's, Terre-Neuve, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00481267
Message ID:
00481311
Vues:
8
>Hi,
>
>I'm trying to run this select statement but I am getting an error on the first BETWEEN().
>
>
>
Select * from C:\WCONNECT\DASHDATA\AGRMASTE.DBF where ;
>	(Reason_cd != 30 OR Reason_cd != 34 OR Reason_cd != 41) AND;
>	(Proj_Stat = "C" OR Proj_Stat = "F") AND;
>	(BETWEEN(Start_Date,{2000/04/01},{2001/03/31}) OR;
>	 BETWEEN(End_Date,{2000/04/01},{2001/03/31}) OR;
>	 BETWEEN(END_DT2,{2000/04/01},{2001/03/31}) OR;
>	 BETWEEN(END_DT3,{2000/04/01},{2001/03/31})) AND;
>
>Can anyone see what the problem might be?
>
>Jolene

What kind of error are you getting?

ALso I would like to point out that condition
(Reason_cd != 30 OR Reason_cd != 34 OR Reason_cd != 41)
is always True
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform