USP_WEALTHPOINTSEARCHHISTORY_RETRIEVERESULTS_UPDATE

Executes the "WealthPoint Search History: Retrieve Results Update" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



                    CREATE procedure dbo.USP_WEALTHPOINTSEARCHHISTORY_RETRIEVERESULTS_UPDATE
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as begin
                        set nocount on;

                        declare @CURRENTSTATUSCODE smallint = null;
                        declare @CURRENTPARSING bit = null;

                        select
                            @CURRENTSTATUSCODE = SH.[STATUSCODE],
                            @CURRENTPARSING = SH.[PARSING]
                        from
                            dbo.[WPSEARCHHISTORY] SH
                        where
                            SH.[ID] = @ID;

                        if (@CURRENTSTATUSCODE <> 2) or (@CURRENTPARSING <> 0) begin
                            raiserror('INVALIDSEARCHHISTORYSTATE',13,1);
                        end
                        else begin
                            update
                                dbo.[WPSEARCHHISTORY]
                            set
                                [PARSING] = 1;
                        end
                    end