BXOR

[Lyle Fairfield]

Is BXOR a JET 4.0 SQL operator?

How can I get DAO to use BXOR in a query,
eg SELECT ID, (ID BXOR 2) as IDBXORedWith2 from Table1
?

(Access 2003)

--
Lyle Fairfield

[Br]

Lyle Fairfield wrote:

Is BXOR a JET 4.0 SQL operator?

How can I get DAO to use BXOR in a query,
eg SELECT ID, (ID BXOR 2) as IDBXORedWith2 from Table1
?

(Access 2003)

Not in Jet4. You'd have to build you're own function to do it.

But I believe BAND is available if you use ADO.

eg.
Dim rs As New ADODB.Recordset
Dim strSql As String
strSql = "SELECT myField, (myField BAND 8) <> 0 FROM myTable;"
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[lylefair]

Br@dley wrote:

Lyle Fairfield wrote:

Is BXOR a JET 4.0 SQL operator?

How can I get DAO to use BXOR in a query,
eg SELECT ID, (ID BXOR 2) as IDBXORedWith2 from Table1

Not in Jet4. You'd have to build you're own function to do it. No; I've done a bit more reading since my original post. It's a
reserved word in JET 4.0 SQL and works just a BAND does..
But I believe BAND is available if you use ADO.

Yes. But my question is, (one more time):

BXOR is a reserved word in JET 4.0. It's a bitwise operator, evaluating
to the equivalent, (TTBOMK) as VBA's XOR ie [bits]: (0,0) => 0,
(1,1)=>0, (0,1)=>1, (1,0)=>1. Very very simple encryption schemes (eg
Yahoo Messenger XORs mesage strings with the user's log name
repetitively for its log files) use XOR, so it's quite a handy
operator. I use XORs as false trails when I want to be REALLY obtuse
(when actually I am using the Crypt API).

DAO is the "natural" technology of JET 4.0.
So how can we use BAND (or BXOR or BNOT etc) in DAO?