USP_DATAFORMTEMPLATE_EDIT_BBAIMPORTFILESCONFIGURATION
The save procedure used by the edit dataform template "Target Analytics Import Files Configuration Edit 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. |
| @AUXILIARYRESEARCHGROUPSIZE | int | IN | WealthPoint batch processing size |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBAIMPORTFILESCONFIGURATION (
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@AUXILIARYRESEARCHGROUPSIZE int
) as
set nocount on;
declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @ID = null;
select top 1
@ID = ID
from
dbo.BBAIMPORTFILES;
begin try
if @ID is null begin
insert into dbo.BBAIMPORTFILES (
ID,
AUXILIARYRESEARCHGROUPSIZE,
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED
) values (
newid(),
@AUXILIARYRESEARCHGROUPSIZE,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE
);
end
else begin
update
dbo.BBAIMPORTFILES
set
AUXILIARYRESEARCHGROUPSIZE = @AUXILIARYRESEARCHGROUPSIZE,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = @CURRENTDATE
from
dbo.BBAIMPORTFILES
where
ID = @ID;
end
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;