Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
What I have found is that it picks or uses the last value for the field that it encounters, in the case of the Max function, it will choose the value attached to the record that meets the max condition, so it will work, but it is not really technically correct. A hidden feature!
>>You could also add posname to the view, which works with VFP sql but breaks ANSI Sql (all fields must be in the group by except summation fields).
>
>It works, in the sense that it won't err, but it does not pick the posname value from the right record. When it does it is a coincidence.
Précédent
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