USP_DATAFORMTEMPLATE_ADD_GROUPGOAL
The save procedure used by the add dataform template "Group Goal Add Data Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @GROUPID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @GROUPGOALUNITCODEID | uniqueidentifier | IN | Type |
| @AMOUNT | int | IN | Goal |
| @STARTDATE | datetime | IN | Start date |
| @GOALDATE | datetime | IN | End date |
| @DESCRIPTION | nvarchar(200) | IN | Description |
| @NAME | nvarchar(50) | IN | Name |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_GROUPGOAL
(
@ID uniqueidentifier = null output,
@GROUPID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@GROUPGOALUNITCODEID uniqueidentifier,
@AMOUNT integer,
@STARTDATE datetime = null,
@GOALDATE datetime = null,
@DESCRIPTION nvarchar(200) = '',
@NAME nvarchar(50) = ''
)
as
set nocount on;
exec dbo.USP_GROUPGOAL_ADD @ID, @GROUPID, @CHANGEAGENTID, 0, @GROUPGOALUNITCODEID, @AMOUNT, @GOALDATE, @STARTDATE, @DESCRIPTION, @NAME
return 0