By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,072 Members | 1,200 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,072 IT Pros & Developers. It's quick & easy.

BXOR

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
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?

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.