Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to do this?
Message
De
03/01/2000 13:16:12
 
 
À
02/01/2000 20:48:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Divers
Thread ID:
00311422
Message ID:
00311782
Vues:
14
Assuming your table of wages is indexed on employee you could populate a cursor, empl, with the name of employees whose wages you want summed by doing:
SELECT employee, SUM(wages) as total_wage ;
FROM wagetabl WHERE employee IN ;
(SELECT employee FROM empl ;
GROUP BY 1 ;
ORDER BY 1

In the future, please provide a more descriptive subject than "How to do this?"

>Using SQL may involve millions of records while there might be least then 10 items in my grid. I want the fastest way to get the same result.
>Your comment is welcome.
>BTW, it seems that there is no way to sum up a specific grid column with several keystrokes.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform