
Contents
9.10 String parameters...........................................................................................................................311
String processing functions..................................................................................................................................... 311
Assigning string parameters....................................................................................................................................312
Chain-linking string parameters.............................................................................................................................. 313
Converting a numerical value to a string parameter..........................................................................................314
Copying a substring from a string parameter..................................................................................................... 315
Reading system data.................................................................................................................................................316
Converting a string parameter to a numerical value..........................................................................................317
Testing a string parameter.......................................................................................................................................318
Finding the length of a string parameter.............................................................................................................. 319
Comparing alphabetic priority................................................................................................................................. 320
Reading out machine parameters.......................................................................................................................... 321
9.11 Preassigned Q parameters............................................................................................................. 324
Values from the PLC: Q100 to Q107..................................................................................................................... 324
Active tool radius: Q108............................................................................................................................................324
Tool axis: Q109........................................................................................................................................................... 325
Spindle status: Q110..................................................................................................................................................325
Coolant on/off: Q111.................................................................................................................................................325
Overlap factor: Q112..................................................................................................................................................325
Unit of measurement for dimensions in the NC program: Q113.....................................................................325
Tool length: Q114....................................................................................................................................................... 326
Coordinates after probing during program run................................................................................................... 326
Deviation between actual and nominal value during automatic tool measurement; for example, with the
TT 160...........................................................................................................................................................................326
Tilting the working plane with workpiece angles: Coordinates calculated by the control for rotary
axes................................................................................................................................................................................326
Measurement results from touch probe cycles.................................................................................................. 327
9.12 Accessing tables with SQL statements.......................................................................................... 330
Introduction..................................................................................................................................................................330
Programming SQL commands................................................................................................................................332
Overview of functions................................................................................................................................................333
SQL BIND......................................................................................................................................................................334
SQL EXECUTE..............................................................................................................................................................335
SQL FETCH.................................................................................................................................................................. 339
SQL UPDATE................................................................................................................................................................341
SQL INSERT.................................................................................................................................................................343
SQL COMMIT...............................................................................................................................................................344
SQL ROLLBACK...........................................................................................................................................................345
SQL SELECT.................................................................................................................................................................347
Examples...................................................................................................................................................................... 349
9.13 Programming examples..................................................................................................................351
Example: Rounding a value......................................................................................................................................351
Example: Ellipse.......................................................................................................................................................... 352
HEIDENHAIN | TNC620 | Klartext Programming User's Manual | 01/2022 19