USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATION_ORGANIZATION

The load procedure used by the edit dataform template "Education Organization Data 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.
@ORGANIZATIONNAME	nvarchar(100)	INOUT	Name
@INDUSTRYCODEID	uniqueidentifier	INOUT	Industry
@NUMEMPLOYEES	int	INOUT	No. of employees
@NUMSUBSIDIARIES	int	INOUT	No. of subsidiaries
@PARENTCORPID	uniqueidentifier	INOUT	Parent org
@PICTURE	varbinary	INOUT	Image
@PICTURETHUMBNAIL	varbinary	INOUT	Image thumbnail
@PICTURECHANGED	bit	INOUT	Picture changed?
@WEBADDRESS	UDT_WEBADDRESS	INOUT	Website
@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.
@ISPRIMARY	bit	INOUT	This is a primary organization

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EDUCATION_ORGANIZATION(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ORGANIZATIONNAME nvarchar(100) = null output, 
    @INDUSTRYCODEID uniqueidentifier = null output,            
    @NUMEMPLOYEES int = null output,
    @NUMSUBSIDIARIES int = null output,
    @PARENTCORPID uniqueidentifier = null output,    
    @PICTURE varbinary(max) = null output,
    @PICTURETHUMBNAIL varbinary(max) = null output,
    @PICTURECHANGED bit = null output,
    @WEBADDRESS dbo.UDT_WEBADDRESS = null output,
    @TSLONG bigint = 0 output,    
    @ISPRIMARY bit = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows

    set @DATALOADED = 0
    set @TSLONG = 0

    exec USP_DATAFORMTEMPLATE_EDITLOAD_ORGANIZATION_2
        @ID,
        @DATALOADED output,
        @ORGANIZATIONNAME output, 
        @INDUSTRYCODEID output,    
        @NUMEMPLOYEES output,
        @NUMSUBSIDIARIES output,
        @PARENTCORPID output,
        @PICTURE output,
        @PICTURETHUMBNAIL output,
        @PICTURECHANGED output,
        @WEBADDRESS output,
        @TSLONG output,
        @ISPRIMARY output   

    return 0;