Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
For Clause in Createindex()
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Titre:
For Clause in Createindex()
Divers
Thread ID:
00485415
Message ID:
00485415
Vues:
37
I like to use conditional indexes for my customer maintenance form. I have a Financial app so clients that still owe me money vs all clients is important. I need to flip back and forth at will so I use the power of the index.

This code works in the command window:
index on upper(lname)+upper(fname) tag ilname

index on upper(lname)+upper(fname);
for bal_due> 0 tag lname

This is the code in the postinithook:
sele v_accnt_buyers
with this
.createindex('v_accnt_buyers','index on upper(lname)+upper(fname) tag ilname')
.createindex('v_accnt_buyers','index on upper(lname)+upper(fname);
for bal_due> 0 tag lname')
endwith

I always error on the second createindex line?

__Stephen
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform