USP_DATAFORMTEMPLATE_LOAD_AUTOMATCHOPTIONS

The load procedure used by the view dataform template "NetCommunity Auto-Match Options View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@USELASTNAME	bit	INOUT	Use last name
@USEFIRSTNAME	bit	INOUT	Use first name
@USEMIDDLENAME	bit	INOUT	Use middle name
@USEMAIDENNAME	bit	INOUT	Use maiden name
@USEBIRTHDATE	bit	INOUT	Use birthdate
@USEGENDER	bit	INOUT	Use gender
@USEADDRESS	bit	INOUT	Use address
@USECITY	bit	INOUT	Use city
@USECOUNTRY	bit	INOUT	Use country
@USECOUNTY	bit	INOUT	Use county
@USENZCITY	bit	INOUT	Use NZ city
@USENZSUBURB	bit	INOUT	Use NZ suburb
@USESTATE	bit	INOUT	Use state
@USEZIP	bit	INOUT	Use ZIP
@USEPHONE	bit	INOUT	Use phone
@USELOOKUPID	bit	INOUT	Use lookup ID
@EXACTMATCH	bit	INOUT	Exact match only
@INCLUDEINACTIVE	bit	INOUT	Include inactive
@INCLUDEDECEASED	bit	INOUT	Include deceased
@USESUFFIX	bit	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_LOAD_AUTOMATCHOPTIONS
                (
                    @DATALOADED bit = 0 output,
                    @USELASTNAME bit = null output,
                    @USEFIRSTNAME bit = null output,
                    @USEMIDDLENAME bit = null output,
                    @USEMAIDENNAME bit = null output,
                    @USEBIRTHDATE bit = null output,
                    @USEGENDER bit = null output,
                    @USEADDRESS bit = null output,
                    @USECITY bit = null output,
                    @USECOUNTRY bit = null output,
                    @USECOUNTY bit = null output,
                    @USENZCITY bit = null output,
                    @USENZSUBURB bit = null output,
                    @USESTATE bit = null output,
                    @USEZIP bit = null output,
                    @USEPHONE bit = null output,                
                    @USELOOKUPID bit = null output,
                    @EXACTMATCH bit = null output,
                    @INCLUDEINACTIVE bit = null output,
                    @INCLUDEDECEASED bit = null output,
          @USESUFFIX bit = null output
                )
                as
                set nocount on;

                begin try
                    exec dbo.USP_BBNC_GETAUTOMATCHOPTIONS 
                        @USELASTNAME = @USELASTNAME output,
                        @USEFIRSTNAME = @USEFIRSTNAME output,
                        @USEMIDDLENAME = @USEMIDDLENAME output,
                        @USEMAIDENNAME = @USEMAIDENNAME output,
                        @USEBIRTHDATE = @USEBIRTHDATE output,
                        @USEGENDER = @USEGENDER output,
                        @USEADDRESS = @USEADDRESS output,
                        @USECITY = @USECITY output,
                        @USECOUNTRY =@USECOUNTRY output,
                        @USECOUNTY = @USECOUNTY output,
                        @USENZCITY = @USENZCITY output,
                        @USENZSUBURB = @USENZSUBURB output,
                        @USESTATE = @USESTATE output,
                        @USEZIP = @USEZIP output,
                        @USEPHONE = @USEPHONE output,    
                        @USELOOKUPID = @USELOOKUPID output,            
                        @EXACTMATCH = @EXACTMATCH output,
                        @INCLUDEINACTIVE = @INCLUDEINACTIVE output,
                        @INCLUDEDECEASED = @INCLUDEDECEASED output,
            @USESUFFIX = @USESUFFIX output;

                    set @DATALOADED = 1;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;