Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need help with SELECT
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Need help with SELECT
Divers
Thread ID:
00174354
Message ID:
00174354
Vues:
63
What's wrong with my SELECT statement below?

Error I get - "Command contains unrecognized phrase/keyword."

I am trying to select records for a certain year that have a certain ID code and count/list them by month for assorted zip codes.

cField = cRetVal

SELECT mytable.zip, mytable.date ;
FROM mytable ;
WHERE YEAR(mytable.date) = YEAR(DATE())-1 .AND. ;
WHERE mytable.&cField = "1A" .OR. ;
mytable.&cField = "1B" .OR. ;
mytable.&cField = "1C" .OR. ;
ORDER BY MONTH(mytable.date) ;
INTO CURSOR rpt

Thanks for helping me out.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform