Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Missing operand (apparently)
Message
From
31/12/2006 17:34:26
 
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:
01181140
Views:
8
There is no #DEFINE. There are only those two fields in the analysis table.
localcrime1 has nnval (n), crimetype(c), crimedate(d), crimehour(n) and shapename(c) for fields
I'll remove the & from the names, try it and report back. But, other crimetypes with the & in the name work fine.
-----------------------------------------------
>What other fields do you have in 'localcrime1'?
>Do you have #DEFINE somewhere that redefines COUNT or one of it parts?
>Do you still get an error if you remove "&" from names.
>
...
>INLIST(Alltrim(Crimetype), "BE Garage", "BE Home", "Home invasion", "BE Business", "BE Cabin" ) ;
>...
>There's also simpler way to get result you want with SQL?
>
>SELECT Month(CrimeDate)= 1 AS MonthNumber, COUNT(*) as counter ;
>	FROM localcrime1 ;
>	WHERE Alltrim(Crimetype) IN ("B&E Garage", "B&E Home", "Home invasion", "B&E Business", "B&E Cabin" ) ;
>	GROUP BY 1 ;
>	INTO ARRAY laStat		
>	
>SELECT Analyse
>FOR i=1 TO ALEN (laStat,1)
>	GOTO (laStat[1])
>	REPLACE statvalue WITH laStat[2]
>ENDFOR
>
>
>
>>I am still getting an error after the code change.
>>I am gathering stats for a twelve month graph from a crime file.
>>Here is all the code (It's in a menu procedure)
>>
>>Each line of code that counts is generating the error.
>>I get this error message "Command contains unrecognized phrase/keyword"
>>
><snip>
I ain't skeert of nuttin eh?
Yikes! What was that?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform