Here's the SP that toggles a Bit datatype. How would I make it comething
like
???
update pcpmanufacturers set def = not (def) where ManufID = @ManufID
----------------------------------------------------------------------
create Procedure pcp_manufToggle
@ManufID int
as
Set nocount on
declare @S as bit
select @s = def from pcpManufacturers where ManufID = @ManufID
if (@s = 1) begin
update pcpManufacturers set def=0 where manufID = @ManufID
end
else begin
update pcpmanufacturers set def=1 where manufid = @manufID
end
TIA
Pete
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
