USP_DATAFORMTEMPLATE_EDIT_GROUPGOAL
The save procedure used by the edit dataform template "Group Goal Edit Data Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter indicating the ID of the record being edited. |
| @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_EDIT_GROUPGOAL (
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@GROUPGOALUNITCODEID uniqueidentifier,
@AMOUNT integer,
@STARTDATE datetime,
@GOALDATE datetime,
@DESCRIPTION nvarchar(200),
@NAME nvarchar(50)
)
as
set nocount on;
exec dbo.USP_GROUPGOAL_EDIT @ID, @CHANGEAGENTID, @GROUPGOALUNITCODEID, @AMOUNT, @GOALDATE, @STARTDATE, @DESCRIPTION, @NAME
return 0;