HEIDENHAIN TNC 620 (340 56x-01) - Manual (Page 427)

HEIDENHAIN TNC 620 427
1
0
.9 A
c
cessing T
a
bles with SQL Commands
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 reports the result:
0: No error occurred.
1: Error occurred (incorrect handle or index too large)
 Data bank: SQL access ID: Q parameter with the
handle for identifying the result set (also see SQL
SELECT
).
 Data bank: Index for SQL result: Row 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.
Example: Row number is transferred in a
Q parameter
11 SQL BIND Q881 "TAB_EXAMPLE.MEAS_NO"
12 SQL BIND Q882 "TAB_EXAMPLE.MEAS_X"
13 SQL BIND Q883 "TAB_EXAMPLE.MEAS_Y"
14 SQL BIND Q884 "TAB_EXAMPLE.MEAS_Z"
. . .
20 SQL Q5 "SELECT MEAS_NO,MEAS_X,MEAS_Y,
MEAS_Z FROM TAB_EXAMPLE"
. . .
30 SQL FETCH Q1 HANDLE Q5 INDEX+Q2
Example: Row number is programmed directly
. . .
30 SQL FETCH Q1 HANDLE Q5 INDEX5