USP_DATAFORMTEMPLATE_EDIT_COAUPDATE

The save procedure used by the edit dataform template "AddressFinder Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(150)	IN	Name
@DESCRIPTION	nvarchar(250)	IN	Description
@SITEID	uniqueidentifier	IN	Site
@PRIMARYCONTACTNAME	nvarchar(250)	IN	Name
@PRIMARYCONTACTEMAIL	UDT_EMAILADDRESS	IN	Email address
@PRIMARYCONTACTPHONE	nvarchar(20)	IN	Phone number
@ALTERNATECONTACTNAME	nvarchar(250)	IN	Name
@ALTERNATECONTACTEMAIL	UDT_EMAILADDRESS	IN	Email address
@ALTERNATECONTACTPHONE	nvarchar(20)	IN	Phone number
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_COAUPDATE
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @NAME nvarchar(150),
  @DESCRIPTION nvarchar(250),
  @SITEID uniqueidentifier,
  @PRIMARYCONTACTNAME nvarchar(250),
  @PRIMARYCONTACTEMAIL dbo.UDT_EMAILADDRESS,
  @PRIMARYCONTACTPHONE nvarchar(20),
  @ALTERNATECONTACTNAME nvarchar(250),
  @ALTERNATECONTACTEMAIL dbo.UDT_EMAILADDRESS,
  @ALTERNATECONTACTPHONE nvarchar(20),
  @CURRENTAPPUSERID uniqueidentifier
)

as
  set nocount on;

  declare @PRIMARYCONTACTTITLECODEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_COAUPDATE
    @ID = @ID,
    @PRIMARYCONTACTTITLECODEID = @PRIMARYCONTACTTITLECODEID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_COAUPDATE_2
    @ID,
    @CHANGEAGENTID,
    @NAME,
    @DESCRIPTION,
    @SITEID,
    @PRIMARYCONTACTNAME,
    @PRIMARYCONTACTEMAIL,
    @PRIMARYCONTACTPHONE,
    @ALTERNATECONTACTNAME,
    @ALTERNATECONTACTEMAIL,
    @ALTERNATECONTACTPHONE,
    @CURRENTAPPUSERID,
    @PRIMARYCONTACTTITLECODEID

  return 0;