USP_SITECOPYSTATUS_UPDATE

The save procedure used by the add dataform template "**Site Copy Status Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CopyBatchGUID	uniqueidentifier	IN
@ErrorLog	nvarchar(256)	IN
@Status	int	IN

Definition

Copy



                    CREATE procedure dbo.USP_SITECOPYSTATUS_UPDATE
                    (
                    @ID uniqueidentifier = null output,
                    @CopyBatchGUID uniqueidentifier,
                    @ErrorLog nvarchar(256),
                    @Status int
                    )
                    as

                    set nocount on;

                    begin try

                      UPDATE dbo.SiteCopy SET Status = @Status, ErrorLog = ErrorLog + @ErrorLog + CHAR(13)
                      WHERE ID = @CopyBatchGUID

                  end try

                  begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                  end catch

                  return 0