Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Formula for converting multi choice into a number
Message
From
29/11/2012 09:22:33
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01558333
Message ID:
01558335
Views:
122
This message has been marked as the solution to the initial question of the thread.
Why not use binary values?

Choice 1 ---- 1
Choice 2 ---- 2
Choice 3 ---- 4
Choice 4 ---- 8
Choice 5 ---- 16
Choice 6 ---- 32

Sum the values to store them. You can then easily retrieve which choices were selected.

lnX = the sum

To check if Choice 1 was selected : ?Bittest(lnX,0)
To check if Choice 2 was selected : ?Bittest(lnX,1)
To check if Choice 3 was selected : ?Bittest(lnX,2)
Note that the value after lnX is one lower than expected, since Bittest() is zero based.

>Hi,
>
>I am looking for a formula (if possible) to convert a multiple choice(s) into a number. Kind of like the VFP Anchor property bit value works. Here is my example:
>Choice 1 ---- ##
>Choice 2 ---- ##
>Choice 3 ---- ##
>Choice 4 ---- ##
>Choice 5 ---- ##
>Choice 6 ---- ##
>
>Each choice above would have a number (##). Then when a user checks any number of choices (from 1 to 6), the "total" number is calculated. This "total" number should be unique for any combination of the selected choices. So that this number can be used (in reverse) to see what choices it represent.
>Any suggestions?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform