USP_DATAFORMTEMPLATE_ADD_GLOBALCHANGE_PRELOAD_2

The load procedure used by the edit dataform template "Global Change Add Form 2"

Parameters

Parameter Parameter Type Mode Description
@GLOBALCHANGECATALOGID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@DISPLAYNAME nvarchar(100) INOUT GLOBALCHANGENAME

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_GLOBALCHANGE_PRELOAD_2(
                        @GLOBALCHANGECATALOGID uniqueidentifier,
                        @DISPLAYNAME nvarchar(100) = null output
                    )
                    as
                        set nocount on;

                        select 
                            @DISPLAYNAME = DISPLAYNAME 
                        from 
                            dbo.GLOBALCHANGECATALOG
                        where
                            GLOBALCHANGECATALOG.ID = @GLOBALCHANGECATALOGID;