USP_DATAFORMTEMPLATE_ADD_CONTACTREPORTFILEPROSPECT_PRELOAD

The load procedure used by the edit dataform template "Contact Report File With Prospect Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@STATUSCODE	int	INOUT	Status
@PROSPECTID	uniqueidentifier	INOUT	PROSPECTID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_CONTACTREPORTFILEPROSPECT_PRELOAD
(
    @PROSPECTPLANID uniqueidentifier,
    @STATUSCODE int = null output,
    @PROSPECTID uniqueidentifier = null output
)
as
    set nocount on;

    select 
        @PROSPECTID = PROSPECTID,
        @STATUSCODE = 2
    from dbo.PROSPECTPLAN 
    where ID = @PROSPECTPLANID;

    return 0;