HEIDENHAIN TNC 620 (73498x-01) ISO programming - Manual (Page 241)

HEIDENHAIN TNC 620 241
8.8 A
ccessing tables with SQL commands
Programming SQL commands
Program SQL commands in the Programming mode:
U Call the SQL functions by pressing the SQL soft key
U 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.