spClone_ProfileEditorFields

Parameters

Parameter	Parameter Type	Mode
@PKCloneID	int	IN
@PKCloneFromID	int	IN
@CurrentUsersID	int	IN

Definition

Copy



    CREATE    PROCEDURE dbo.spClone_ProfileEditorFields
    (
          @PKCloneID        int,
        @PKCloneFromID  int,
        @CurrentUsersID int
    )

    AS
        declare @newGuid uniqueidentifier
        SET @newGuid = NEWID()

    INSERT INTO ProfileEditorFields
    (
        FieldID,
        Caption,
        Editable,
        Required,
        AllowDelete,
        AllowPrivate,
        UseCodeTable,
        AllowNewCodes,
        ContentID,
        Include,
        FieldAttribID,
        ShowInGrid
    )
    select
            FieldID,
        Caption,
        Editable,
        Required,
        AllowDelete,
        AllowPrivate,
        UseCodeTable,
        AllowNewCodes,
        @PKCloneID,
        Include,
        FieldAttribID,
        ShowInGrid

    from ProfileEditorFields where ContentID = @PKCloneFromID

    exec spAuditThis @CurrentUsersID, 1, @NewGuid, 1