Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT AND AVG()
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00022385
Message ID:
00022442
Vues:
49
>>> Bruce
>>>
>>> What is a "Select Top 3" ???
>>>
>>> Per
>>
>>in VFP5.0 there were several enhancemnts nade to the SELECT - SQL command
>>one of them is a new TOP clause that lets you get the TOP n or TOP n % of a query
>>look in the help file
>>
>>Arnon
>
>Arnon
>I have VFP 3.0 and have today installed VFP 5.0 but
>so far after x minutes (GPF) occures for no good reason
>
>so is there a way in 3.0???

Let's see...in vfp3 you can index on desired order, get the value of the third record, do SQL for records >= to that value into cursor, then get average...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform