On 12/12/08 11:18 AM, "Ron" <[email protected]> wrote in whole or in part:
> What do most developers do for a field that should be Yes/No, since there is
> no Boolean data type?
>
> FM 8.5
>
> Ron
>
Starting from all versions. I create a value list "one" with the single
value "1". Then I use a checkbox on the layout with this valuelist for any
field I want to "toggle/boolean".
Yes. "empty" is not the same thing as "0". If you need 1/0, then create a
button on the checkbox with the script step:
Set Field [ myfield; abs( myfield -1 ) ]
AND auto-enter "0" in the field definitions, to start out "off".
I usually test for NOT "1" and let it go at that (empty, 0, all the same)
rather than the script step. But some things must be "on/off" and never
empty....
--
Beverly Voth Tier3 Data & Web Services Group, LLC
606-864-0041 http://www.tier3web.com/xml.htm
Web Design & Hosting * Apple: CAN, ACN & ADC
Certified FileMaker 7 & 9 Developer * FileMaker Business Alliance
Coldfusion, Witango, PHP, MS SQL, MySQL, FMP, XML/XSLT, CSS
Over 14 years experience integrating databases and the internet!
