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:
00175190
Views:
29
Hi Steve,

I've taken your code and ammended it as such only to make it work with one of my existing tables.

set path to "c:\december 1999"

cField1 = "timekeeper"
cField2 = "date"

SELECT mytable.&cField1, mytable.&cField2 FROM entry as mytable ;
WHERE YEAR(mytable.&cField2) < YEAR(DATE()) ;
ORDER BY mytable.&cField1 ;
INTO CURSOR rpt

This worked WITHOUT a problem.
Juan L. Romero
gcandela@javanet.com
Previous
Reply
Map
View

Click here to load this message in the networking platform