HEIDENHAIN TNC 640 (34059x-05) - Manual (Page 334)

Programming: Q Parameters
9.9 Accessing tables with SQL commands
9
334
TNC 640 | User's Manual
HEIDENHAIN Conversational Programming | 1/2015
Programming SQL commands
This function can only be programmed if you have
entered the code number 555343.
Program SQL commands in the
Programming mode:
Press the
SPEC FCT key
Press the PROGRAM FUNCTIONS soft key.
Shift the soft-key row
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
Soft key Function
SQL BIND
Bind a Q parameter to a table column
SQL SELECT
Select table rows
SQL EXECUTE
Program a Select command
SQL FETCH
Read table rows from the result set and save them
in Q parameters
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.
SQL COMMIT
Transfer table rows from the result set into the
table and conclude the transaction.
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