HEIDENHAIN TNC 320 (340 551-01) - Manual (Page 348)

348 10 Programming: Q Parameters
1
0
.9 A
ccessing T
a
bles with SQL Commands
Programming SQL commands
Program SQL commands in the Programming and Editing mode:
8 Call the SQL functions by pressing the SQL soft key.
8 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.