If you use INTEGER you can do Boolean operations using arithmetic. Mulitplying is "and" and addition is "or". You just need to check for zero or non-zero.
Example: IF (Col1='Y' and (col2='Y' or col3='Y')) or (col4='Y' and (col2='Y' or col5='Y')) becomes IF col1*(col2+col3) +col4*(col2+col5)>0 Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca 416 512 6950 > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey M. > Watson > Sent: April 18, 2008 10:53 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Friday question > > I would use an integer just out of ease. is it T F or Y N etc? 0 and 1 > is pretty unmistakable and just as checkbox-friendly. As far is I know > I think this just comes down to preference. > > Jeff Watson [EMAIL PROTECTED] > Tube Methods, Inc. > 610-279-7700 > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jan > Johansen > Sent: Friday, April 18, 2008 10:49 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Friday question > > G'Day, > > I need to add several columns to a table that will basically hold > True/False information. > > In the past I have always handled this with a TEXT column > defaulted to N and being able to change to Y. > But I'm curious now if this kind of information > is better handled with an INTEGER defaulted to 0 > and using 1 as true. > > Opinions? > > Jan > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.524 / Virus Database: 269.23.1/1385 - Release Date: 18/04/2008 9:30 > AM > No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.1/1385 - Release Date: 18/04/2008 9:30 AM
