Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Missing operand (apparently)
Message
From
01/01/2007 12:48:32
 
 
To
01/01/2007 12:45:57
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:
01181212
Views:
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.
>>
>>Don't know if it will help, but you might also try
>>"B"+CHR(38)+"E Garage"
>>"B"+CHR(38)+"E Home"
>>
>>etc.
>
>
>I get the error when I compile now and not when I run the code.
>I changed "&" to "and" and for good measure I changed 'Home' to 'Residence'
>
>Compiling c:\squeezer\mainmenu.mpr
>Count to JanCount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and  Month(CrimeDate)= 1
>Error in line 2411: Command contains unrecognized phrase/keyword.
>Count to FebCount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and Month(CrimeDate)= 2
>Error in line 2416: Command contains unrecognized phrase/keyword.
>Count to MarCount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and Month(CrimeDate)= 3
>Error in line 2421: Command contains unrecognized phrase/keyword.
>Count to AprCount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and Month(CrimeDate)= 4
>Error in line 2426: Command contains unrecognized phrase/keyword.
>Count to MayCount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and Month(CrimeDate)= 5
>Error in line 2431: Command contains unrecognized phrase/keyword.
>Count to JunCount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and Month(CrimeDate)= 6
>Error in line 2436: Command contains unrecognized phrase/keyword.
>Count to Julcount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and Month(CrimeDate)= 7
>Error in line 2441: Command contains unrecognized phrase/keyword.
>Count to AugCount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and Month(CrimeDate)= 8
>Error in line 2446: Command contains unrecognized phrase/keyword.
>Count to Sepcount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and Month(CrimeDate)= 9
>Error in line 2451: Command contains unrecognized phrase/keyword.
>Count to Octcount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and Month(CrimeDate)= 10
>Error in line 2456: Command contains unrecognized phrase/keyword.
>Count to Novcount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and Month(CrimeDate)= 11
>Error in line 2461: Command contains unrecognized phrase/keyword.
>Count to Deccount for Alltrim(Crimetype) INLIST("B and E Garage", "B and E Residence", "Residence invasion", "B and E Business", "B and E Cabin" ) and Month(CrimeDate)= 12
>Error in line 2466: Command contains unrecognized phrase/keyword.
>
>
>No matter how much I stare at the code, I cannot see the problem.
>
>Grady
Should I perform the Alltrim before the code line and use a variable in the count line instead of a field?
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