spUpdate_ApplicationFieldPrivacyDefault
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FieldID | int | IN | |
| @AttribID | int | IN | |
| @PublicByDefault | bit | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spUpdate_ApplicationFieldPrivacyDefault]
(
@FieldID int,
@AttribID int,
@PublicByDefault bit
)
AS
begin
set nocount on
Update dbo.ApplicationFields
set
PrivateShowByDefault=@PublicByDefault
where fieldid=@fieldID
and AttribTypeID=@AttribID
and PrivateShowByDefault <> @PublicByDefault
end