Inserts a record on the specified Database Table.
Parameters
|
Table
|
| |
Database Table where to insert the new record.
|
| |
|
Values <string> or <numeric>
|
| |
Value to assign to the specified Column. This expression will be evaluated accordingly with the Type column. |
| |
|
Ignore Database Masks
|
| |
If you've defined a Output Mask for the specified Column in the Table properties and:
This option is checked
|
-
|
You must specify the value in the Kalipso format.
|
This option is unchecked
|
-
|
You must specify the value in the Mask format. |
|
| |
|
Duplicate Quotes
|
| |
Check this option to automatically duplicate the quote (') character on the Values specified, to correctly insert the record in the database. For further information take a look at the examples below. |
|
| This function generates an SQL Insert operation that exists in every SQL database, and is used to insert a record in the database.
Consider you want to insert records in the following Database Table:
| Products |
| Code |
Name |
Stock |
empty
|
|
Example 1
|
|
Example 2 |
| Table |
Products |
| |
| Columns |
Type |
Values |
| Code |
Numeric |
100 |
| Name |
String |
"Coca Cola 'Updated" |
| Stock |
Numeric |
400 |
|
| Duplicate Quotes |
No |
Result:
| Products |
| Code |
Name |
Stock |
empty
|
Note: It originates a syntax error because parameter Duplicate Quotes is disabled, therefore no record is inserted.
|
|
| Table |
Products |
| |
| Colums |
Type |
Values |
| Code |
Numeric |
100 |
| Name |
String |
"Coca Cola 'Updated" |
| Stock |
Numeric |
400 |
|
| Duplicate Quotes |
Yes |
Result:
| Products |
| Code |
Name |
Stock |
| 100 |
Coca Cola 'Updated |
400 |
|
|
Updated: 3/21/2018 5:40 PM
| 
