HEIDENHAIN TNC 128 (77184x-02) - Manual (Page 225)

Accessing tables with SQL commands 8.9
8
TNC 128 | User's Manual HEIDENHAIN Conversational Programming | 5/2014
225
Programming SQL commands
This function can only be programmed if you have
entered the code number 555343.
Program SQL commands in the Programming mode:
To select the MOD functions, press
SQL
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.