USP_DATAFORMTEMPLATE_EDITLOAD_ADDRESSBOOKFAF

The load procedure used by the edit dataform template "AddressBookFAF 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.
@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.
@FIRSTNAME	nvarchar(255)	INOUT	Firstname
@LASTNAME	nvarchar(255)	INOUT	Lastname
@MIDDLENAME	nvarchar(100)	INOUT	Middlename
@TITLECODEID	uniqueidentifier	INOUT	Title
@SALUTATION	nvarchar(255)	INOUT	Salutation
@EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Emailaddress
@HOMEPHONE	nvarchar(25)	INOUT	Homephone
@CELLPHONE	nvarchar(25)	INOUT	Cellphone
@ADDRESSBLOCK	nvarchar(300)	INOUT	Addressblock
@CITY	nvarchar(100)	INOUT	City
@STATEID	uniqueidentifier	INOUT	State
@COUNTRYID	uniqueidentifier	INOUT	Country
@POSTCODE	nvarchar(24)	INOUT	Postcode
@PREFERREDCOMMUNICATIONCODE	tinyint	INOUT	Preferredcommunication
@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	Secondary City
@SECONDARYSTATEID	uniqueidentifier	INOUT	Secondary State
@SECONDARYPOSTCODE	nvarchar(24)	INOUT	Secondary PostCode
@SECONDARYCOUNTRYID	uniqueidentifier	INOUT	Secondary Country
@COMPANYNAME	nvarchar(255)	INOUT	Company name
@NOTES	nvarchar(1000)	INOUT	Notes

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ADDRESSBOOKFAF
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @FIRSTNAME nvarchar(255) = null output,
    @LASTNAME nvarchar(255) = null output,
    @MIDDLENAME nvarchar(100) = null output,
    @TITLECODEID uniqueidentifier = null output,
    @SALUTATION nvarchar(255) = null output,
    @EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
    @HOMEPHONE nvarchar(25) = null output,
    @CELLPHONE nvarchar(25) = null output,
    @ADDRESSBLOCK nvarchar(300) = null output,
    @CITY nvarchar(100) = null output,
    @STATEID uniqueidentifier = null output,
    @COUNTRYID uniqueidentifier = null output,
    @POSTCODE nvarchar(24) = null output,
    @PREFERREDCOMMUNICATIONCODE tinyint = 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
    , @SECONDARYSTATEID uniqueidentifier = null output
    , @SECONDARYPOSTCODE nvarchar(24) = null output
    , @SECONDARYCOUNTRYID uniqueidentifier = null output

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

    set nocount on;

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

    set @DATALOADED = 0
    set @TSLONG = 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.  Also note that we fetch the TSLONG so that concurrency

    -- can be considered.

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @FIRSTNAME = FIRSTNAME, 
        @LASTNAME = LASTNAME, 
        @MIDDLENAME = MIDDLENAME, 
        @TITLECODEID = TITLECODEID, 
        @SALUTATION = SALUTATION, 
        @EMAILADDRESS = EMAILADDRESS, 
        @HOMEPHONE = HOMEPHONE, 
        @CELLPHONE = CELLPHONE, 
        @ADDRESSBLOCK = ADDRESSBLOCK, 
        @CITY = CITY, 
        @STATEID = STATEID, 
        @COUNTRYID = COUNTRYID, 
        @POSTCODE = POSTCODE, 
        @PREFERREDCOMMUNICATIONCODE = PREFERREDCOMMUNICATIONCODE,

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

        @SECONDARYCITY = SECONDARYCITY, 
        @SECONDARYSTATEID = SECONDARYSTATEID, 
        @SECONDARYCOUNTRYID = SECONDARYCOUNTRYID, 
        @SECONDARYPOSTCODE = SECONDARYPOSTCODE,

        @COMPANYNAME = COMPANYNAME, 
        @NOTES = NOTES 

    from dbo.ADDRESSBOOKFAF
    where ID = @ID

    return 0;