USP_OLAPSMARTFIELDSELECTION_EDIT
The save procedure used by the edit dataform template "OLAP smart field selection 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. |
| @ELIGIBLESMARTFIELDS | xml | IN | Eligible smart fields |
| @SELECTEDSMARTFIELDS | xml | IN | Selected smart fields |
Definition
Copy
CREATE procedure dbo.[USP_OLAPSMARTFIELDSELECTION_EDIT]
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@ELIGIBLESMARTFIELDS xml,
@SELECTEDSMARTFIELDS xml
)
as
set nocount on;
if @CHANGEAGENTID is null
exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;
declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
exec dbo.[USP_OLAP_GETEXISTINGOLAPSMARTFIELDS_UPDATEFROMXML] @ID, @SELECTEDSMARTFIELDS, @CHANGEAGENTID, @CURRENTDATE;
return 0;