Skip to main content

SQL Database Execute

Overview

Executes an SQL statement on a specific database

Returns
Data Structure

Parameters

ParameterParameterValid BlocksRequired
Use Dynamic NameShow the Dynamic Name slot in the tree so that it can be set dynamicallyBoolean Block GroupNo
Dynamic NameThe dynamic name of this itemText Block GroupNo
AttributesMetadata values for this block. Used in XML and multipart/form-data.Text Block GroupNo
Database Connection ConfigA connection configuration that was setup in the Databases panelText Block GroupNo
Custom Connection NameA custom connection configuration that was setup within the LogixText Block GroupNo
QuerySQL query to be executedDatabase Query Block GroupNo