Re: Bitwise manipulation for an update statement.

Adrian Scott-Day wrote:

> Could anyone shead some light on this problem that I'm faced with.
>
> I have a stored procedure that has 2 parameters. The first is the
> primary key for the table that is to be updated. The second is an
> integer. This integer is actually a bitwise status flag.(1=locked,
> 2=reviewed, 4=invalid...)
>
> The issue that I am facing is that I need to change the value for a
> large number of fields within this particular table, but only modify
> the relevant bits.
> For example record1 has a value of 4 in it's statusA field which means
> it is marked as invalid but not locked and not reviewed.
> Record1 has a value of 5 in it's statusB field which means it is
> marked as invalid and locked but not reviewed.
> The stored procedure then passes the primary key to select record1 and
> an integer value of 1, thereby indicating that the "locked" bit of the
> statusA and statusB fields should be set.
>
> How can I do this?

I am completely unclear as to what it is you are doing and why you have any problem at all.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)