HEIDENHAIN TNC 128 (77184x-02) - Manual (Page 230)

Programming: Q Parameters
8.9 Accessing tables with SQL commands
8
230
TNC 128 | User's Manual HEIDENHAIN Conversational Programming | 5/2014
SQL UPDATE
SQL UPDATE transfers the data prepared in the Q parameters into the
row of the result set addressed with
INDEX. The existing row in the
result set is completely overwritten.
SQL UPDATE 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, index too large,
value outside of value range or incorrect data
format)
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 prepared in the Q
parameters are written to this row. If you do not
enter an index, the first row is written to (n=0).
Either enter the row number directly or program the
Q parameter containing the index
Row number is transferred in a Q
parameter
11 SQL BIND Q881
"TAB_EXAMPLE.MESS_NR"
12 SQL BIND Q882
"TAB_EXAMPLE.MESS_X"
13 SQL BIND Q883
"TAB_EXAMPLE.MESS_Y"
14 SQL BIND Q884
"TAB_EXAMPLE.MESS_Z"
. . .
20 SQL Q5 "SELECT
MESS_NR,MESS_X,MESS_Y,MESS_Z
FROM TAB_EXAMPLE"
. . .
30 SQL FETCH Q1 HANDLE Q5 INDEX
+Q2
Row number is programmed directly
. . .
40 SQL UPDATEQ1 HANDLE Q5 INDEX5
SQL INSERT
SQL INSERT generates a new row in the result set and transfers the
data prepared in the Q parameters into the new row.
SQL INSERT takes into account all columns entered in the "Select"
command. Table columns not entered in the "Select" command are
filled with default values.
Parameter no. for result: Q parameter, in which
the SQL server has reported the result:
0: No error occurred
1: Error occurred (incorrect handle, value outside of
value range or incorrect data format)
Database: SQL access ID: Q parameter with the
handle for identifying the result set (also see
SQL
SELECT).
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"
. . .
40 SQL INSERTQ1 HANDLE Q5