USP_DATAFORMTEMPLATE_ADD_FUNDINGREQUESTMEDIALINK_PRELOAD

The load procedure used by the edit dataform template "Funding Request Media Link Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@FUNDINGREQUESTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@AUTHORID	uniqueidentifier	INOUT	Author

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FUNDINGREQUESTMEDIALINK_PRELOAD
            (
                @CURRENTAPPUSERID uniqueidentifier,
                @FUNDINGREQUESTID uniqueidentifier,
                @AUTHORID uniqueidentifier = null output
            )
            as
                set nocount on;

                select top 1
                    @AUTHORID = CONSTITUENTID
                from
                    dbo.APPUSER
                where
                    ID = @CURRENTAPPUSERID;

                return 0;