Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Complex Index expression
Message
De
03/11/2008 13:26:30
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01359216
Message ID:
01359225
Vues:
32
May I ask WHY you need such an index tag? If you have index tags on the relevant fields, a SQL Select statement is normally instant, and most likely gives you exactly what you really want.

>Hi,
>
>I'm trying to create an index with the balance in descending order (first by time, then by balance). I can not figure this out.
>
>I tried this expression, but it's not working and I don't see why
>
>index on IIF(cStatus='PAYMENT ARRANGEMENT BROKEN','0','1') + DTOS(TTOD(tScheduleTime)) + ;
>*PADL(99999999999999 - yBalance,14,'0') tag tSchedule FOR !DELETED()
>
>Thanks.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform