USP_DATAFORMTEMPLATE_EDITLOAD_DESIGNATION

The load procedure used by the edit dataform template "Designation Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DESIGNATIONREPORT1CODEID	uniqueidentifier	INOUT	Report code 1
@DESIGNATIONREPORT2CODEID	uniqueidentifier	INOUT	Report code 2
@USERID	nvarchar(512)	INOUT	Lookup ID
@VANITYNAME	nvarchar(512)	INOUT	Public name
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DESIGNATION
                    (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,            
                        @DESIGNATIONREPORT1CODEID uniqueidentifier = null output,
                        @DESIGNATIONREPORT2CODEID uniqueidentifier = null output,
                        @USERID nvarchar(512) = null output,
                        @VANITYNAME nvarchar(512) = null output,
                        @TSLONG bigint = 0 output
                    )
                    as
                        set nocount on;

                        set @DATALOADED = 0;
                        set @TSLONG = 0;

                        select
                            @DATALOADED = 1,
                            @DESIGNATIONREPORT1CODEID = DESIGNATIONREPORT1CODEID,
                            @DESIGNATIONREPORT2CODEID = DESIGNATIONREPORT2CODEID,
                            @TSLONG = TSLONG,
                            @USERID = USERID,
                            @VANITYNAME = VANITYNAME
                        from
                            dbo.DESIGNATION
                        where ID = @ID;

                        return 0;