Android Question SQLite 64bit AND query

Robert Valentino said:

64bit AND in a SQLite

Click to expand...

Normally you don't do a bit and/or operation in a modern database What are you trying to do?

I have 64bit data fields that I want to select
Look at it this way.

Blue = 0x01
Red = 0x02
Green= 0x04
Pink =0x08

Take this out -- another 30 bits or more for 60 colors (NOTE just using colors as an example)

Now I ask you what you desire. You pick your options and I "OR" them together and do a "select xxx where (Colors & YourChoices) "
AND-ing one INTEGER to another will produce a list of matches without a lot of compare

SQLite supports & (and) and | (or): https://www.sqlite.org/lang_expr.html

Did you get any error?

No, I didn't. Just about to start converting a lot of lines of code and wanted to get it right the first time.

I know B4A needs to have special routines for & (and) and | (or) when using longs. Didn't know if SQLite would have a problem.

All this code works in windows, was hoping it would be an easy port.

Thanks for the clarification

BobVal

The SQL commands are passed as is to the SQLite engine.