Contents
Display Legacy Contents

 Print
    INSERT  
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

     
 

    See also
    Samples

     

    Updated
    : 3/21/2018 5:40 PM