Information générale
Titre:
Difference between tables and cursors?
Why is it when I try to SUM() on a cursor, I get a result of the first record's data multiplied by reccount(). If I attempt the same thing on a table, the result is correct?
SUM(user.amount) TO xx
If I use a table with 2 records, the first amount = 2 second amount = 3, the answer is 5. If I do the same command on a cursor, the answer is 4. It seems to take the first value it sees as all values.
Any suggestions?
M. Carpio
MIS - Pep Boys
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement