USP_DATAFORMTEMPLATE_EDIT_FAFVANITYURL

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN	The input ID parameter indicating the ID of the record being edited.
@REALMTYPEID	int	IN
@REALMID	int	IN
@CLIENTUSERID	int	IN
@PAGEID	int	IN
@TABID	int	IN
@VANITYURL	nvarchar(255)	IN
@TARGETURL	nvarchar(max)	IN
@CLIENTSITESID	int	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FAFVANITYURL
(
      @ID int,
    @REALMTYPEID int,
    @REALMID int,
    @CLIENTUSERID int,
    @PAGEID int,
    @TABID int,
    @VANITYURL nvarchar(255),
    @TARGETURL nvarchar(max),
    @CLIENTSITESID int
)
as

    set nocount on;

    begin try
        -- handle updating the data
        update dbo.VANITYURL set
           REALMTYPEID = @REALMTYPEID, 
        REALMID = @REALMID, 
        CLIENTUSERID = @CLIENTUSERID, 
        PAGEID = @PAGEID,
        TABID = @TABID,
        VANITYURL = @VANITYURL,
        TARGETURL = @TARGETURL,
        CLIENTSITESID = @CLIENTSITESID,
        DATECHANGED = GetDate()
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;