Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is wrong with this...
Message
 
 
To
02/03/2001 06:37:25
Jolene Dicks
Human Resources Development Canada
St. John's, Newfoundland, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00481267
Message ID:
00481311
Views:
9
>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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform