HEIDENHAIN TNC 620 E, User Manual

Page: 429 / 840

Programming Q Parameters | Accessing tables with SQL commands
10
HEIDENHAIN | TNC 620 | Conversational Programming User's Manual | 10/2017
429
Step Explanation
5
Complete
transaction The transaction is concluded and the used resources are released
6
Remove
binding The binding between table columns and QS parameters is removed (release of necessary
resources)
7
Delete
synonym The synonym is deleted again (release of necessary resources)
SQL BIND
Example: binding Q parameters to table columns
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"
Example: remove binding
91 SQL BIND Q881
92 SQL BIND Q882
93 SQL BIND Q883
94 SQL BIND Q884
SQL BIND
links a Q parameter to a table column. The SQL
commands
FETCH
,
UPDATE
, and
INSERT
evaluate this binding
(assignment) for the data transfer between the
result set
(intermediate memory) and the NC program.
An
SQL BIND
command without a table or column name cancels
the link. The link is terminated at the end of the NC program or
subprogram, if not before.
Programming notes:
You can program any number of bindings. During
read and write operations, the only columns taken
into consideration are those that are specified using
the
SELECT
command. If you specify columns
without binding in the
SELECT
command, then the
control will interrupt the read or write operation with
an error message.
SQL BIND...
must be programmed before the
FETCH
,
UPDATE
, and
INSERT
commands.
Parameter no. for result
: define Q parameter
for binding to the table column
Database: column name
: define table name and
table column (separate with
.
)
Table name : synonym or path with filename
of the table
Column name : name displayed in the table
editor