HEIDENHAIN TNC 320, User Manual

Page: 309 / 581

Accessing tables with SQL commands 9.9
9
TNC 320 | User's Manual
HEIDENHAIN Conversational Programming | 3/2014
309
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 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