Printable View
I am using an Access 2000 db and have a set of boolean values that are bit packed. This scheme works fine and I can get around the DAO limitations inside of Access, but I am having a hard time figuring out how to do it from inside VB. The query wolud look something like:
Select * from table where (fieldname bitwise-equal value);
Any suggestions?
:confused:
by bit-packed I assume you mean a string similiar to: "0011001" where each character represents the presence or absence of some condition?
if so, you can use the mid function:
where mid$([fieldname],position,1)="1"
No. I mean that each bit in the field value represents a true or false position. Therefore, if I have eight boolean parameters the state of the parameters is represented by the bit value in a single byte of information. For example,
T F T T F T F FT ==> 10110101 in the byte which gives it a value of 179