OpenSqlList Function

Help Contents

Introduction

Opens a new query on the tag database.

Syntax

Informal Syntax:

OpenSqlList( Title, AutoUpdate, SQL )

Formal Syntax:

OpenSqlList( Title:=Expression, AutoUpdate:=Expression, SQL:=Expression )

Parameters

ParameterTypeDescription
TitleANY_STRINGThe title of the SQL list.
AutoUpdate BOOL Whether the list automatically refreshes. Use TRUE to turn on automatic refresh. Use FALSE to turn off automatic refresh.
SQL ANY_STRING The SQL SELECT Query to display in the list. See SQL Language for the syntax of this parameter.

Return Value

None.

Remarks

The OpenSqlList function executes an SQL query and displays the results in a table. The exact behavior varies according to the context:

A program or script will not execute any statements after the OpenSQLList call.

Examples

  1. Display a list of Data Point Tags:
    OpenSqlList( 
        "Digital Tags", 
        TRUE, 
        "SELECT FullName,DisplayValue,DisplayUnits FROM TagDataPoint" );

Further Information

Operator Actions

To learn where you can use this function.

Structured Text Function Call

To learn about calling a function from IEC 61131-3 structured text.

IEC 61131-3 Expressions

To learn about the different types of expression to use as function parameters.

SQL Language

To learn about the syntax of SQL statements in Fernhill SCADA.

Glossary

For the meaning of terms used in Fernhill SCADA.