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?