Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ASCENDING and DESCENDING indexes?
Message
From
01/03/1999 16:39:10
 
 
To
01/03/1999 16:34:46
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00192865
Message ID:
00192869
Views:
20
>Hello Edward,
>
>I want to index on on group of logical fields (DESCENDING) and a character field (ASCENDING)

You may do something like:
INDEX ON IIF(logfield1=.T.,"B","A")+IIF(logfield2=.T.,"A","B").... +charfield TAG Mytag
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform