Insert
Kalipso - Form - Actions - Actions Description - Group Database - Insert
Inserts a record on the specified Database Table.
Action available for the following operating systems:

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.
Usage
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
empty
empty
Example 1
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
empty
empty
It originates a syntax error because parameter Duplicate Quotes is disabled, therefore no record is inserted.
Example 2
Table
Products
Columns
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
Last updated