HEIDENHAIN TNC 640 (34059x-05) - Manual (Page 338)

Programming: Q Parameters
9.9 Accessing tables with SQL commands
9
338
TNC 640 | User's Manual
HEIDENHAIN Conversational Programming | 1/2015
SQL FETCH
SQL FETCH reads the row addressed with INDEX from the result set,
and places the table entries in the bound (assigned) Q parameters.
The result set is addressed with the
HANDLE.
SQL FETCH takes into account all columns entered in the "Select"
command.
Parameter no. for result: Q parameter, in which
the SQL server has reported the result:
0: No error occurred
1: Error occurred (incorrect handle or index too
large)
Database: SQL access ID: Q parameter with the
handle for identifying the result set (also see
SQL
SELECT).
Database: Index to SQL result: Line number within
the result set. The table entries of this row are read
and are transferred into the bound Q parameters.
If you do not enter an index, the first row is read
(n=0).
Either enter the row number directly or program the
Q parameter containing the index
Row number is transferred in a Q
parameter
11SQL BIND Q881
"TAB_EXAMPLE.MEAS_NO"
12SQL BIND Q882
"TAB_EXAMPLE.MEAS_X"
13SQL BIND Q883
"TAB_EXAMPLE.MEAS_Y"
14SQL BIND Q884
"TAB_EXAMPLE.MEAS_Z"
. . .
20SQL Q5 "SELECT
MEAS_NO,MEAS_X,MEAS_Y,
MEAS_Z FROM TAB_EXAMPLE"
. . .
30 SQL FETCH Q1HANDLE Q5 INDEX
+Q2
Row number is programmed directly
. . .
30 SQL FETCH Q1HANDLE Q5 INDEX5