Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need SELECT help please
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00175160
Message ID:
00175172
Views:
29
In the code you provided, you have not defined cField contained in you ORDER clause. I am assuming this is a typo and as we all know, you can sometimes spend hours finding it.

SELECT mytable.&cField, mytable.&cField2 FROM mytable ;
WHERE YEAR(mytable.&cField2) = YEAR(DATE()) ;
ORDER BY mytable.&cField ;
INTO CURSOR rpt
Juan L. Romero
gcandela@javanet.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform