Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
This page provides details of the properties for the save action. This is a node in an actionflow.
Overview
In an actionflow, use a save action node to insert, update or delete records for a selected table.
Allocating Primary Key Values to New Records
When the save action is inserting a new record to the table, PhixFlow allocates a unique primary key value to the record. How PhixFlow allocates a value is determined by the Stream properties → Advanced → Primary Key Generator.
- Internal: By default, PhixFlow automatically allocates a unique, numeric value to the primary key attribute.
- Sequence: Configure PhixFlow to allocate a value from your own sequence using the Primary Key Generator Sequence option. see Stream > Data Generation Options and Sequence.
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Basic Settings
Field | Description | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Name | Enter the name for the action node. | ||||||||||||||||||||
|
| ||||||||||||||||||||
Type |
| ||||||||||||||||||||
Table | The table where the data is going to be updated. |
Attributes
A list of attributes to be updated. Click to show the list of attributes for the table. Drag the attributes you want to add to the save node into this list.
In the list:
- to edit the attribute's properties, double-click an attribute; see View Attributes Reference Information
- to delete an attribute, right-click and select
Insert excerpt _delete _delete nopanel true
Note |
---|
Attributes not added to this list will not be changed. If a record is being inserted and an attribute is not present in the save node, the default value for this field will be _NULL |
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|