HEIDENHAIN TNC 620 Programming Station

Programming Qparameters | Accessing tables with SQL statements
Overview of functions
Overview of soft keys
The control offers the following ways of working with SQL
commands:
Soft key Function Page
SQL BIND creates or disconnects a
binding between table columns and Q
or QS parameters
334
SQL EXECUTE opens a transaction
for selected table columns and table
rows or enables the use of other
SQL instructions (miscellaneous
functions).
335
SQL FETCH transfers the values to the
bound Q parameters
339
SQL ROLLBACK discards all changes
and concludes the transaction
345
SQL COMMIT saves all changes and
concludes the transaction
344
SQL UPDATE expands the transaction
to include the change of an existing
row
341
SQL INSERT creates a new table row 343
SQL SELECT reads out a single value
from a table and does not open any
transaction
347
9
HEIDENHAIN | TNC620 | Klartext Programming User's Manual | 01/2022
333