USP_DATAFORMTEMPLATE_ADD_GROUPMEMBER_PRELOAD
The load procedure used by the edit dataform template "Group Member Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @GROUPID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @GROUPNAME | nvarchar(154) | INOUT | Group |
| @STARTDATE | date | INOUT | Start date |
| @RECORDTYPEID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_GROUPMEMBER_PRELOAD
(
@GROUPID uniqueidentifier,
@GROUPNAME nvarchar(154) = null output,
@STARTDATE date = null output,
@RECORDTYPEID uniqueidentifier = null output
)
as
select
@GROUPNAME = C.NAME,
@STARTDATE = GROUPDATA.STARTDATE
from
dbo.CONSTITUENT as C
inner join
dbo.GROUPDATA on GROUPDATA.ID = C.ID
where
C.ID = @GROUPID;
select @RECORDTYPEID = ID
from dbo.RECORDTYPE
where NAME = 'Constituent';
return 0;