[AccessD] brain farts

John Colby jcolby at colbyconsulting.com
Wed Oct 29 16:30:45 CST 2003


Ohhhhh, that's what I was wanting.  I couldn't find that stuff anywhere in
NOT Help.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Wednesday, October 29, 2003 5:04 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] brain farts


Sure you can.  You need to use the "bitwise" oprators, not the
logical operators:

& (Bitwise AND),
| (Bitwise OR) ,
^ (Bitwise Exclusive OR)
~ (Bitwise NOT)

On 29 Oct 2003 at 15:37, James Barash wrote:

> John,
> As far as I know, you cannot use bitwise functions in an SQL statement.
> You need to create a function to do the comparison. For example:
>
> Public Function BinaryOr(ByVal val1 As Long, ByVal val2 As Long) As Long
>     BinaryOr = (val1 Or val2)
> End Function
>
> Create one function for each binary comparison you need or you could
> create one function and pass the operator you want to use.
> Hope this helps.
>
> James Barash
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
> Sent: Wednesday, October 29, 2003 2:12 PM
> To: AccessD
> Subject: [AccessD] brain farts
>
>
> Folks,
>
> I'm trying to do boolean operations in a query.  I have a table with bit
> mapped fields such that the long integer has bits "on" or 1 in specific
> circumstances.  Now I want to OR in other numbers in SQL.  I have a SQL
> statement that looks like:
>
> SELECT MsysForms.FRM_GroupOpen, ([MsysForms]![frm_GroupOpen] Or 1) AS
> NewVal FROM MsysForms;
>
> regardless of the value contained in the field frm_GroupOpen, the NewVal
> is always -1 for an OR or an AND of any other value, and 0 for an XOR.
>
> If I have a 4 in the field, 4 OR 1 should give me 5, but it is giving me
> -1. I believe it is "interpreting" it and saying it is true.  But why?
>
> John W. Colby
> www.colbyconsulting.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list