LinkedListFromSQLCommandColumn Function

Help Contents

Introduction

The LinkedListFromSQLCommandColumn Function creates a LinkedList Data Object from a column of a SQLCommand Data Object.

Syntax

Informal Syntax:

LinkedListFromSQLCommandColumn( SQLCommandID, ColumnIndex )

Formal Syntax:

LinkedListFromSQLCommandColumn( 
        SQLCommandID:=Expression,
        ColumnIndex:=Expression )

Parameters

The LinkedListFromSQLCommandColumn Function has these parameters.

Parameter Type Description
SQLCommandID DINT The identifier of the SQLCommand Data Object.
ColumnIndex ANY_INT The zero-based index of the column to convert to a LinkedList Data Object.

Return Value

The function returns a DINT value representing the LinkedList Object.

Remarks

One entry is added to the LinkedList Data Object for each row in the SQLCommand Data Object.

The function reports a runtime error if the SQLCommandID parameter does not refer to a valid SQLCommand Data Object.

Standards Compliance

The LinkedListFromSqlCommandColumn Function is an extension to the IEC 61131-3 standard.

Further Information

LinkedList Functions

For information about functions to manage LinkedList data objects.

Data Objects

For information about all Data Objects supported by Fernhill SCADA.

IEC 61131-3

To learn how IEC 61131-3 is used in Fernhill SCADA.

Glossary

For the meaning of terms used in Fernhill SCADA.