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

Programming Q Parameters | Accessing tables with SQL commands
10
446
HEIDENHAIN | TNC 640 | Conversational Programming User's Manual | 10/2017
SQL INSERT
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"
. . .
40 SQL INSERT Q1 HANDLE Q5
SQL UPDATE
creates a new row in the
result set
(intermediate
memory). The values of the individual cells are copied from the
bound Q parameters. The transaction is defined via the
HANDLE
to
be specified.
SQL INSERT
takes all columns into consideration that were
specified with the
SELECT
instruction (SQL command
SQL
EXECUTE
). Table columns without corresponding
SELECT
instruction (not contained in the query result) are assigned defaults
values.
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)