USP_DATAFORMTEMPLATE_ADD_BUSINESSPROCESSEXPORTMULTIPLE
The save procedure used by the add dataform template "Business Process Export Multiple Files Add Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @OUTPUTPATH | nvarchar(2047) | IN | Output path |
| @COLUMNNAME | nvarchar(255) | IN | Create one file per |
| @FILEPREFIX | nvarchar(100) | IN | File prefix |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @EXPORTFORMAT | nvarchar(5) | IN | Export format |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_BUSINESSPROCESSEXPORTMULTIPLE]
(
@ID uniqueidentifier = null output,
@OUTPUTPATH nvarchar(2047),
@COLUMNNAME nvarchar(255),
@FILEPREFIX nvarchar(100) = null,
@CHANGEAGENTID uniqueidentifier = null,
@EXPORTFORMAT nvarchar(5) = 'csv'
)
as
set nocount on;
-- this is just a dummy form for UI purposes only - just set the return ID so the platform thinks everything worked
set @ID = newid();
return 0;