HEIDENHAIN TNC 640, Руководство пользователя, Страница: 444 / 948

Programming Q Parameters | Accessing tables with SQL commands
10
444
HEIDENHAIN | TNC 640 | Conversational Programming User's Manual | 10/2017
SQL FETCH
Example: transferring row number in the 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: programming the row number directly
. . .
30 SQL FETCH Q1 HANDLE Q5 INDEX5
SQL FETCH
reads a row out of the
result-set
(intermediate
memory). The values of the individual cells are stored in the bound
Q parameters. The transaction is defined via the
HANDLE
to be
specified; the row is defined via the
INDEX
.
SQL FETCH
takes all columns into consideration that were
specified with the
SELECT
instruction (SQL command
SQL
EXECUTE
).
Parameter No. for result
(return value for the
control):
0
successful transaction
1
successful transaction
Database: SQL access ID
: define Q parameters
for the
HANDLE
(for identifying the transaction)
Database: index to SQL result
: row number
within the
result set
Program the row number directly
Program the Q parameter containing the
index
The row (n=0) is read if nothing is specified
The optional syntax elements
IGNORE UNBOUND
and
UNDEFINE MISSING
are intended for the machine tool
builder.