Logic Guide - EXECUTE_SQL (Built-in Functions, Function Blocks, and Conversions)

EXECUTE_SQL

Function Name	EXECUTE_SQL
Description	Executes an SQL Query. The SQL Query is executed at the end of the Logic program execution process, during the write outputs phase.
Arguments	SQL {STRING} The SQL is a valid SQL Query statement. For more information on the data types for the inputs and outputs, see Data Type Hierarchy.
Returns	Boolean. The SQL executes at the end of the Logic program and the success (True) or failure (FALSE) of the SQL statement is not available to the Logic program.

Function Name

EXECUTE_SQL

Description

Executes an SQL Query. The SQL Query is executed at the end of the Logic program execution process, during the write outputs phase.

Arguments

SQL {STRING}

The SQL is a valid SQL Query statement.

For more information on the data types for the inputs and outputs, see Data Type Hierarchy.

Returns

Boolean.

The SQL executes at the end of the Logic program and the success (True) or failure (FALSE) of the SQL statement is not available to the Logic program.

The preferred way of inserting, updating or deleting data via SQL from Logic is to use the %D in the variable syntax (see Inserting, Updating, and Deleting Values by Using SQL in an ST Program).

EXECUTE_SQL is deprecated and is retained for backward compatibility only.