USP_DATAFORMTEMPLATE_VIEW_ADDRESSBOOKFAF

The load procedure used by the view dataform template "AddressBookFAF View 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.
@FIRSTNAME	nvarchar(255)	INOUT	First name
@MIDDLENAME	nvarchar(100)	INOUT	Middle name
@LASTNAME	nvarchar(255)	INOUT	Last name
@TITLECODE	nvarchar(50)	INOUT	Title
@PREFERREDCOMMUNICATIONCODE	tinyint	INOUT	Preferred communication
@SALUTATION	nvarchar(255)	INOUT	Salutation
@EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Emailaddress
@ADDRESSBLOCK	nvarchar(300)	INOUT	Address block
@CITY	nvarchar(100)	INOUT	City
@STATE	nvarchar(50)	INOUT	State
@POSTCODE	nvarchar(24)	INOUT	Postcode
@COUNTRY	nvarchar(50)	INOUT	Country
@CELLPHONE	nvarchar(25)	INOUT	Cell phone
@TEXTMESSAGESEND	bit	INOUT	Text message send
@HOMEPHONE	nvarchar(25)	INOUT	Home Phone
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent ID
@BUSINESSPHONE	nvarchar(25)	INOUT	Business phone
@BUSINESSADDRESS	nvarchar(300)	INOUT	Business address
@SECONDARYEMAILADDRESS	UDT_EMAILADDRESS	INOUT	Secondary Email address
@SECONDARYCITY	nvarchar(100)	INOUT	City
@SECONDARYSTATE	nvarchar(50)	INOUT	State
@SECONDARYPOSTCODE	nvarchar(24)	INOUT	Postcode
@SECONDARYCOUNTRY	nvarchar(50)	INOUT	Country
@COMPANYNAME	nvarchar(255)	INOUT	Company name
@NOTES	nvarchar(1000)	INOUT	Notes

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ADDRESSBOOKFAF 
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    --@CONTACTTYPE nvarchar(25)= null output,
  @FIRSTNAME nvarchar(255)= null output,
  @MIDDLENAME nvarchar(100)= null output,
    @LASTNAME nvarchar(255)= null output,
  @TITLECODE nvarchar(50) = null output,
    @PREFERREDCOMMUNICATIONCODE tinyint = null output,
  @SALUTATION nvarchar(255)= null output,
  @EMAILADDRESS dbo.UDT_EMAILADDRESS= null output,
  @ADDRESSBLOCK nvarchar(300)= null output,
  @CITY nvarchar(100)= null output,
  @STATE nvarchar(50)= null output,
  @POSTCODE nvarchar(24)= null output,
    @COUNTRY nvarchar(50) = null output,
  @CELLPHONE nvarchar(25)= null output,
    @TEXTMESSAGESEND bit= null output,
    @HOMEPHONE nvarchar(25)= null output

    , @CONSTITUENTID uniqueidentifier = null output
    , @BUSINESSPHONE nvarchar(25) = null output
    , @BUSINESSADDRESS nvarchar(300) = null output
    , @SECONDARYEMAILADDRESS dbo.UDT_EMAILADDRESS = null output

    , @SECONDARYCITY nvarchar(100) = null output
    , @SECONDARYSTATE nvarchar(50)= null output
    , @SECONDARYPOSTCODE nvarchar(24)= null output
    , @SECONDARYCOUNTRY nvarchar(50) = null output

  , @COMPANYNAME nvarchar(255) = null output
  , @NOTES nvarchar(1000) = null output

)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.
    select @DATALOADED = 1,
           --@CONTACTTYPE= CONTACTTYPE,    
       @FIRSTNAME = FIRSTNAME, 
           @MIDDLENAME = MIDDLENAME, 
       @LASTNAME = LASTNAME, 
       @TITLECODE = (select [DESCRIPTION] from dbo.[TITLECODE] where [TITLECODE].[ID]=[ADDRESSBOOKFAF].[TITLECODEID]),
       @PREFERREDCOMMUNICATIONCODE = PREFERREDCOMMUNICATIONCODE, 
       @SALUTATION = SALUTATION, 
       @EMAILADDRESS = EMAILADDRESS, 
       @ADDRESSBLOCK = ADDRESSBLOCK, 
       @CITY = CITY, 
       @STATE = (select [DESCRIPTION] from dbo.[STATE] where [STATE].[ID]=[ADDRESSBOOKFAF].[STATEID]),
       @POSTCODE = POSTCODE, 
           @COUNTRY = (select [DESCRIPTION] from dbo.[COUNTRY] where [COUNTRY].[ID] = [ADDRESSBOOKFAF].[COUNTRYID]),
       @CELLPHONE = CELLPHONE, 
           @TEXTMESSAGESEND = TEXTMESSAGESEND,
           @HOMEPHONE = HOMEPHONE, 

        @CONSTITUENTID = CONSTITUENTID, 
        @BUSINESSPHONE = BUSINESSPHONE, 
        @BUSINESSADDRESS = BUSINESSADDRESS, 
        @SECONDARYEMAILADDRESS = SECONDARYEMAILADDRESS,

        @SECONDARYCITY = SECONDARYCITY, 
        @SECONDARYSTATE = (select [DESCRIPTION] from dbo.[STATE] where [STATE].[ID]=[ADDRESSBOOKFAF].[STATEID]),
        @SECONDARYPOSTCODE = SECONDARYPOSTCODE, 
        @SECONDARYCOUNTRY = (select [DESCRIPTION] from dbo.[COUNTRY] where [COUNTRY].[ID] = [ADDRESSBOOKFAF].[COUNTRYID]),

    @COMPANYNAME = COMPANYNAME, 
    @NOTES = NOTES

    from dbo.ADDRESSBOOKFAF
    where ID = @ID

    return 0;