Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Missing operand (apparently)
Message
 
 
To
31/12/2006 15:10:33
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01181122
Message ID:
01181123
Views:
9
Hi Grady,

I don't get any errors with your code when run as below. Do you have variable "E" in your code?
CREATE CURSOR mytable (Crimetype c(20), CrimeDate date)
Count to JanCount for ;
	   Alltrim(Crimetype) = "B&E Garage" and Month(CrimeDate)= 1 ;
	or Alltrim(Crimetype)= "B&E Home" and Month(CrimeDate)= 1 ;
	or Alltrim(Crimetype)= "Home invasion" and Month(CrimeDate)= 1 ;
	or Alltrim(Crimetype)= "B&E Business" and Month(CrimeDate)= 1 ;
	or Alltrim(Crimetype)= "B&E Cabin" and Month(CrimeDate)= 1

? jancount
However when you combine AND/OR conditions you shoud use parenthesisis to specify proper order as shown below.
Count to JanCount for ;
	   (Alltrim(Crimetype) = "B&E Garage" and Month(CrimeDate)= 1) ;
	or (Alltrim(Crimetype)= "B&E Home" and Month(CrimeDate)= 1) ;
	or (Alltrim(Crimetype)= "Home invasion" and Month(CrimeDate)= 1) ;
	or (Alltrim(Crimetype)= "B&E Business" and Month(CrimeDate)= 1) ;
	or (Alltrim(Crimetype)= "B&E Cabin" and Month(CrimeDate)= 1)
The conditions could be simplified as shown below
Count to JanCount for ;
		Alltrim(Crimetype) IN("B&E Garage", "B&E Home", "Home invasion", "B&E Business", "B&E Cabin" ) ;
			and Month(CrimeDate)= 1 
>When I test this bit of code, I get a 'missing operand' error.
>I can't see it. Can you?
>
>
>Count to JanCount for Alltrim(Crimetype) = "B&E Garage" and Month(CrimeDate)= 1 ;
>or Alltrim(Crimetype)= "B&E Home" and Month(CrimeDate)= 1 ;
>or Alltrim(Crimetype)= "Home invasion" and Month(CrimeDate)= 1 ;
>or Alltrim(Crimetype)= "B&E Business" and Month(CrimeDate)= 1 ;
>or Alltrim(Crimetype)= "B&E Cabin" and Month(CrimeDate)= 1
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform