Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use logical field (.f.) in a compound index
Message
 
 
À
22/06/2007 11:48:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Divers
Thread ID:
01235052
Message ID:
01235058
Vues:
17
This message has been marked as a message which has helped to the initial question of the thread.
>Greetings all,
>I am attempting to use a logical field name checkStub (.f., or .t.) in a compound index. The code requires the field to remain a logical fields: .f. or .t. I would like to sort in a compound index with a character field named vendCode. I tried:
>
> str(checkStub) + vendCode
>
>but that gives me "invalid type".
>
>Any ideas?
>
>thanks, vince

Do you want .f. at the top or bottom?

If at the top, you may use

iif(CheckStub,'N','Y') + vendCode

Or use transform(CheckStub) + VendCode (and check transform function codes).
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform