USP_DATAFORMTEMPLATE_ADD_PRELOAD_MERCHANDISE_VENDOR

The load procedure used by the edit dataform template "Merchandise Vendor Add Data Form"

Parameters

Parameter	Parameter Type	Mode
@USACOUNTRYID	uniqueidentifier	INOUT
@CANADACOUNTRYID	uniqueidentifier	INOUT
@NEWZEALANDCOUNTRYID	uniqueidentifier	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_MERCHANDISE_VENDOR
                (
                    @USACOUNTRYID uniqueidentifier = null output,
                    @CANADACOUNTRYID uniqueidentifier = null output,
                    @NEWZEALANDCOUNTRYID uniqueidentifier = null output
                )
                as

                set nocount on;

                begin try
                    set @USACOUNTRYID = (select ID from dbo.COUNTRY where DESCRIPTION = 'United States')
                    set @CANADACOUNTRYID = (select ID from dbo.COUNTRY where DESCRIPTION = 'Canada')
                    set @NEWZEALANDCOUNTRYID = (select ID from dbo.COUNTRY where DESCRIPTION = 'New Zealand')
                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

                return 0