Solved

Bit mask error codes

Posted on 2009-05-15
10
402 Views
Last Modified: 2013-11-07
Hi All

We have an application that returns error code data as bit mapped.

ie
1 - error 1
2 - error 2
4 - error 3
8 - error 4
16 error 5

etc

If the app returne either a 1,2,4,8... I kow the error, but more oft than not it is a combination of errors ie

9 - error 1 and error 4.

Does anyone have an algorithm to convert these decimals back ito the error codes. I have a list of codes.

Ideally I'd like to do this on SQL Server, but code behind would be ok.

Andy
0
Comment
Question by:Andy Green
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 16

Expert Comment

by:ToddBeaulieu
ID: 24396504
You need BITWISE operators
declare @ERROR_1 int
declare @ERROR_2 int
declare @ERROR_3 int
declare @ERROR_4 int
 
set @ERROR_1 = 1
set @ERROR_2 = 2
set @ERROR_3 = 4
set @ERROR_4 = 8
 
declare @err int
set @err = @ERROR_1 | @ERROR_3
print '@err = ' + convert(varchar, @err)
 
if (@err & @ERROR_1 = @ERROR_1)
  print 'ERROR 1'
if (@err & @ERROR_2= @ERROR_2)
  print 'ERROR 2'
if (@err & @ERROR_3 = @ERROR_3)
  print 'ERROR 3'
if (@err & @ERROR_4 = @ERROR_4)
  print 'ERROR 4'

Open in new window

0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24396617
You need to use a logical AND operation

DECLARE @Error int
SELECT @Error = 9
SELECT CASE WHEN @Error&1 =0 THEN 'False' ELSE 'True' END as 'Error 1',
CASE WHEN @Error&2 =0 THEN 'False' ELSE 'True' END as 'Error 2',
CASE WHEN @Error&4 =0 THEN 'False' ELSE 'True' END as 'Error 3',
CASE WHEN @Error&8 =0 THEN 'False' ELSE 'True' END as 'Error 4'
0
 
LVL 3

Author Comment

by:Andy Green
ID: 24397769
Not sure I understand your solution, or maybe it's my descrition of the problem.
I get a decimal value from the external app, which when converted to binary, equates to an error code, where ever there ia a 1.
The posible values go up to 1024. ie
1,2,4,8,16,32,64,128,256,512,1024 11 possible errors.
I cant test for every posible combination, how do I take the decimal, convert to binary and map to the error codes.
Andy
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 16

Expert Comment

by:ToddBeaulieu
ID: 24397816
Why wouldn't you test for every condition? You have to, in order to map to the error codes, right?
You do a bit-wise AND against a test code and if the result = the test code, then that error code is contained in the map.
0
 
LVL 3

Author Comment

by:Andy Green
ID: 24397894
I see what you are saying, yes I agree I have to test aginst each of the 11, but I dont see how I get from the decimal to the actual bits, that represent the errors.
I'll take a look over the weekend. Friday at 5 club now  (well I'm late) and that means beer.
Andy
0
 
LVL 16

Accepted Solution

by:
ToddBeaulieu earned 500 total points
ID: 24411161
If you take a number, AND it with another number, it returns a result comprised of every BIT that was 1 in both numbers. Since you want to test for individual errors, you don't care what the "BITS" are. You simply need to see if the error code ANDed with a test error code is exactly equal to the test error code.
0
 
LVL 3

Author Closing Comment

by:Andy Green
ID: 31581950
Thanks - got it now. It was the conversion into binary that stumped me and it does it for you implicitly.

Andy
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24414298
>>I dont see how I get from the decimal to the actual bits<<
You may not have any control over this, but there is no need to use decimals for this, an integer will suffice.  In fact if all you have are 11 variations then a smallint will do.
0
 
LVL 16

Expert Comment

by:ToddBeaulieu
ID: 24414344
"decimal" did not refer to a data type, but rather to "base 10".
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24414545
Ah, good point.  I should read more carefully.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL syntax for max(date) 3 39
sql trace 4 28
SQL - Update field value based on two other fields in same table. 13 43
relocating SQL 2000 18 36
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question