Update PivotDatabase parameters
- Last UpdatedSep 06, 2023
- 2 minute read
You can configure the commands and parameters to update records to the database.
The parameters to use when the database is updated can be defined in the Parameter Collection Editor. Click Browse (...) to open the editor.
Specify the values for an Update Database Parameter:
|
Parameter |
Description |
|---|---|
|
Name |
The name of the field to use in the Update Command, that is, Id is used as @Id. |
|
Data Type |
The data type of the parameter. |
|
Size |
The size of the data type, for example, string. |
|
Source Value Type |
Specifies how to determine the value of this field. If it is Constant, then the Value property is used. If Source Update Type, then it uses the value of the source field, on the record, to which it is linked. |
|
Source Update Field |
This is only applicable if the Source Value Type is Source Update Type. The name of the source field, from the Select Command, that is used. |
|
Value |
This is only applicable if the Source Update Type is Constant. A constant value to use. This is useful if the Update Command uses a stored procedure that other integrations use, to help identify this specific one. |
Format for parameters
The format for the Update Command to use parameters is “@[name]” where name is defined previously.
The format for Text and Stored Procedure is different:
-
Text - Update [Example1] Set IsProcessed = 1 where Id = @Id where Id is the name of the parameter.
-
Stored Procedure - sp_updateExample2
The sp_updateExample2 stored procedure can have one or more parameters, but you do not supply these in the Update Command. Define these parameters in the Update Database Parameters, and give them the same name as the parameter names for the stored procedure.