Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Double index
Message
 
À
05/01/2014 04:09:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01591344
Message ID:
01591369
Vues:
59
clever solution Viv - thanks.
k

>>I would like to arrange in ascending order the average of two fields af1 and af2
>>the solution would be index on af1+af2 to highave
>>
>>the problem is that some of the records do not have an af2 so for these I would need the index to still place the highest of af1
>>together with the averaged af1+af2
>>
>>is there a way to set up the index such that if af2 =0 then index on af1 only, if af2>0 the index on af1+af2
>>
>>Can you please let me know if this is possible and a suggestion on how to formulate the code to create this double index
>>
>>thanks
>>k
>
>
(af1+IIF(af2>0,af2,af1))/2
?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform