Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Missing operand (apparently)
Message
De
31/12/2006 17:34:26
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01181122
Message ID:
01181140
Vues:
9
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform