USP_DATAFORMTEMPLATE_ADD_FUNDRAISINGGOAL
The save procedure used by the add dataform template "Fundraising 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. |
| @AMOUNT | money | IN | Goal |
| @STARTDATE | datetime | IN | Start date |
| @GOALDATE | datetime | IN | End date |
| @DESCRIPTION | nvarchar(200) | IN | Description |
| @NAME | nvarchar(50) | IN | Name |
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FUNDRAISINGGOAL
(
@ID uniqueidentifier = null output,
@GROUPID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@AMOUNT money,
@STARTDATE datetime = null,
@GOALDATE datetime = null,
@DESCRIPTION nvarchar(200) = '',
@NAME nvarchar(50),
@CURRENTAPPUSERID uniqueidentifier = null
)
as
set nocount on;
exec dbo.USP_GROUPGOAL_ADD @ID, @GROUPID, @CHANGEAGENTID, 1, null, @AMOUNT, @GOALDATE, @STARTDATE, @DESCRIPTION, @NAME, @CURRENTAPPUSERID
return 0