1640 HEIDENHAIN Technical Manual MANUALplus 620
Module 9445 Read a single value from a table
Module 9445 reads a single value from a table cell and copies this value to a
string. The cell content is selected via a SQL statement. For a description of
the supported queries, see "SELECT" on page 1628. This SQL statement is
given to the module beforehand.
If the statement contains a string :'Bnnn' or :'Wnnn' or :'Dnnn' (with nnn
reading as number from 0 to the maximal number of BYTEs, WORDs or
DWORDs respectively), this string is replaced by the integer value found in the
associated PLC data.
A decimal point is always used for data types REAL, LENGTH, and FEED. Values
of the data types SIGN, BOOL and TEXT are enclosed in single quotes ( ’).
Constraints:
The module can only be executed within a submit job.
Possible errors:
The module was not called in a submit job
An invalid string address is given to the module
The statement is syntactically not correct
The table given does not exist or is not accessible
The columns given do not exist within the table
More than one column was named in the statement
No record or more than one record were selected by the statement
Call:
PS B/W/D/K <Valid SQL statement>
PS B/W/D/K <String address for the read value>
CM 9445
PL B/W/D <Error number>
For the meaning of the error number, see "Return codes of
PLC Modules 9440 to 9459 (error stack)" on page 1652.
Error recognition:
Marker Value Meaning
NN_GenApiModule
Error
0 Value was read
1 Error. See <Error number>
To Next Page
Loading...
