
Programming Q Parameters | Accessing tables with SQL commands
10
HEIDENHAIN | TNC 640 | Conversational Programming User's Manual | 10/2017
437
Transaction
Example of an SQL transaction:
Assign Q parameters to table columns for read or write access
using
SQL BIND
Select data using
SQL SELECT
or
SQL EXECUTE
with the
SELECT
instruction
Read, change, or add data using
SQL FETCH
,
SQL UPDATE
, and
SQL INSERT
Confirm or discard interaction using
SQL COMMIT
and
SQL
ROLLBACK
Approve bindings between table columns and Q parameters
using
SQL BIND
You must conclude all transactions that have been
started—even exclusively read accesses. Concluding
the transaction is the only way to ensure that changes
and additions are transferred, that locks are removed,
and that used resources are released.
Overview of functions
Overview of soft keys
Soft
key
Command
Page
SQL BIND
establishes or removes connec-
tions between table columns and Q or QS
parameters
SQL EXECUTE
opens a transaction for
selected table columns and table rows or
enables the use of other SQL instructions
(miscellaneous functions).
SQL FETCH
transfers the values to the
bound Q parameters
SQL ROLLBACK
discards all changes and
concludes the transaction
SQL COMMIT
saves all changes and
concludes the transaction
SQL UPDATE
transfers all values from the
bound Q parameters to the table
SQL INSERT
creates a new table row
SQL SELECT
reads out a single values from a
table and does not open any transaction
Summary of Contents for TNC 640
Page 4: ......
Page 5: ...Fundamentals ...
Page 36: ...Contents 36 HEIDENHAIN TNC 640 Conversational Programming User s Manual 10 2017 ...
Page 67: ...1 First Steps with the TNC 640 ...
Page 90: ......
Page 91: ...2 Introduction ...
Page 130: ......
Page 131: ...3 Operating the Touchscreen ...
Page 144: ......
Page 145: ...4 Fundamentals File Management ...
Page 206: ......
Page 207: ...5 Programming Aids ...
Page 236: ......
Page 237: ...6 Tools ...
Page 281: ...7 Programming Contours ...
Page 333: ...8 Data Transfer from CAD Files ...
Page 355: ...9 Subprograms and Program Section Repeats ...
Page 374: ......
Page 375: ...10 Programming Q Parameters ...
Page 478: ......
Page 479: ...11 Miscellaneous Functions ...
Page 501: ...12 Special Functions ...
Page 584: ......
Page 585: ...13 Multiple Axis Machining ...
Page 650: ......
Page 651: ...14 Pallet Management ...
Page 664: ......
Page 665: ...15 Batch Process Manager ...
Page 673: ...16 Turning ...
Page 713: ...17 Manual Operation and Setup ...
Page 797: ...18 Positioning with Manual Data Input ...
Page 803: ...19 Test Run and Program Run ...
Page 843: ...20 MOD Functions ...
Page 881: ...21 Tables and Overviews ...