HEIDENHAIN TNC 620 Programming Station User Manual

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

HEIDENHAIN TNC 620 Programming Station Specifications

General

Brand	HEIDENHAIN
Model	TNC 620 Programming Station
Category	Control Systems
Language	English