Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need SELECT help please
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00175160
Message ID:
00175190
Vues:
30
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform