Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use logical field (.f.) in a compound index
Message
 
 
To
22/06/2007 11:48:24
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01235052
Message ID:
01235058
Views:
18
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform