HEIDENHAIN TNC 320 (34055x-06) - Manual (Page 272)

Programming: Q Parameters
8.9 Accessing tables with SQL commands
8
272
TNC 320 | User's Manual HEIDENHAIN Conversational Programming | 5/2013
Programming SQL commands
This function can only be programmed if you have
entered the code number 555343.
Program SQL commands in the Programming mode:
Call the SQL functions by pressing the SQL soft
key
Select an SQL command via soft key (see
overview) or press the
SQL EXECUTE soft key and
program the SQL command
Overview of the soft keys
Function Soft key
SQL EXECUTE
Program a Select command.
SQL BIND
Bind a Q parameter to a table column.
SQL FETCH
Read table rows from the result set and save them
in Q parameters.
SQL UPDATE
Save data from the Q parameters in an existing
table row in the result set.
SQL INSERT
Save data from the Q parameters in a new table
row in the result set.
SQL COMMIT
Transfer table rows from the result set into the
table and conclude the transaction.
SQL ROLLBACK
If
INDEX is not programmed: Discard any
changes/insertions and conclude the transaction.
If INDEX is programmed: The indexed row
remains in the result set. All other rows are
deleted from the result set. The transaction is
not concluded.