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