Database SQL Block

This Help topic refers to the following editions:
þ
Enterprise þ Professional þ Small Business
.

 

Overview: Run an SQL statement in the database

 

Allowed inputs: many

Allowed outputs: 1

 

Description

This block allows the you to specify an SQL statement in the database. You can use expressions in the SQL statement.

 

Parameters

SQL Statement

Contains the SQL statement to be executed in the database. Supports expressions. Example:

 

Update Invoice Set Status = 3 Where InvoiceId = [InvoiceId]