USP_DATAFORMTEMPLATE_ADD_SMARTFIELD_PRELOAD

The load procedure used by the edit dataform template "Smart Field Add Form"

Parameters

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

Definition

Copy



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

    select 
        @DISPLAYNAME = DISPLAYNAME 
    from 
        dbo.SMARTFIELDCATALOG
    where
        SMARTFIELDCATALOG.ID = @SMARTFIELDCATALOGID;