USP_DATAFORMTEMPLATE_EDITLOAD_MKTMEMBERSHIPRECORDSOURCE
The load procedure used by the edit dataform template "Record Source Membership 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. |
| @QUERYVIEWCATALOGID | uniqueidentifier | INOUT | Membership record source |
| @MEMBERSHIPSYSTEMIDFIELD | nvarchar(255) | INOUT | System record ID |
| @MEMBERIDFIELD | nvarchar(255) | INOUT | Member ID |
| @MEMBERFIELD | nvarchar(255) | INOUT | Member name |
| @GIVENBYIDFIELD | nvarchar(255) | INOUT | Given by ID |
| @GIVENBYFIELD | nvarchar(255) | INOUT | Given by name |
| @EXPIRATIONDATEFIELD | nvarchar(255) | INOUT | Expiration date |
| @ISGIFTFIELD | nvarchar(255) | INOUT | Is gift? |
| @JOINDATEFIELD | nvarchar(255) | INOUT | Join date |
| @LASTRENEWEDONDATEFIELD | nvarchar(255) | INOUT | Last renewed on |
| @LEVELFIELD | nvarchar(255) | INOUT | Level |
| @PROGRAMFIELD | nvarchar(255) | INOUT | Program |
| @SENDRENEWALFIELD | nvarchar(255) | INOUT | Send renewal to |
| @STATUSFIELD | nvarchar(255) | INOUT | Status |
| @TERMFIELD | nvarchar(255) | INOUT | Term |
| @TYPEFIELD | nvarchar(255) | INOUT | Type |
| @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. |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTMEMBERSHIPRECORDSOURCE]
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@QUERYVIEWCATALOGID uniqueidentifier = null output,
@MEMBERSHIPSYSTEMIDFIELD nvarchar(255) = null output,
@MEMBERIDFIELD nvarchar(255) = null output,
@MEMBERFIELD nvarchar(255) = null output,
@GIVENBYIDFIELD nvarchar(255) = null output,
@GIVENBYFIELD nvarchar(255) = null output,
@EXPIRATIONDATEFIELD nvarchar(255) = null output,
@ISGIFTFIELD nvarchar(255) = null output,
@JOINDATEFIELD nvarchar(255) = null output,
@LASTRENEWEDONDATEFIELD nvarchar(255) = null output,
@LEVELFIELD nvarchar(255) = null output,
@PROGRAMFIELD nvarchar(255) = null output,
@SENDRENEWALFIELD nvarchar(255) = null output,
@STATUSFIELD nvarchar(255) = null output,
@TERMFIELD nvarchar(255) = null output,
@TYPEFIELD nvarchar(255) = null output,
@TSLONG bigint = 0 output
)
as
set nocount on;
select
@QUERYVIEWCATALOGID = [QUERYVIEWCATALOGID],
@MEMBERSHIPSYSTEMIDFIELD = [MEMBERSHIPSYSTEMIDFIELD],
@MEMBERIDFIELD = [MEMBERIDFIELD],
@MEMBERFIELD = [MEMBERFIELD],
@GIVENBYIDFIELD = [GIVENBYIDFIELD],
@GIVENBYFIELD = [GIVENBYFIELD],
@EXPIRATIONDATEFIELD = [EXPIRATIONDATEFIELD],
@ISGIFTFIELD = [ISGIFTFIELD],
@JOINDATEFIELD = [JOINDATEFIELD],
@LASTRENEWEDONDATEFIELD = [LASTRENEWEDONDATEFIELD],
@LEVELFIELD = [LEVELFIELD],
@PROGRAMFIELD = [PROGRAMFIELD],
@SENDRENEWALFIELD = [SENDRENEWALFIELD],
@STATUSFIELD = [STATUSFIELD],
@TERMFIELD = [TERMFIELD],
@TYPEFIELD = [TYPEFIELD],
@TSLONG = isnull([TSLONG], 0)
from
dbo.[MKTMEMBERSHIPRECORDSOURCE]
where
[ID] = @ID;
set @DATALOADED = 1; -- the save procedure will create a row if one does not exist
return 0;