Contents
50
HEIDENHAIN | TNC 640 | Conversational Programming User's Manual | 10/2017
SQL EXECUTE......................................................................................................................................441
SQL FETCH.......................................................................................................................................... 444
SQL UPDATE........................................................................................................................................445
SQL INSERT.........................................................................................................................................446
SQL COMMIT...................................................................................................................................... 447
SQL ROLLBACK................................................................................................................................... 448
SQL SELECT........................................................................................................................................ 449
10.10 Entering formulas directly.................................................................................................................450
Entering formulas.................................................................................................................................450
Rules for formulas................................................................................................................................452
Example of entry................................................................................................................................. 453
10.11 String parameters.............................................................................................................................. 454
String processing functions................................................................................................................. 454
Assign string parameters.....................................................................................................................455
Chain-linking string parameters............................................................................................................456
Converting a numerical value to a string parameter............................................................................457
Copying a substring from a string parameter......................................................................................458
Reading system data........................................................................................................................... 459
Converting a string parameter to a numerical value............................................................................460
Testing a string parameter...................................................................................................................461
Finding the length of a string parameter.............................................................................................462
Comparing alphabetic priority.............................................................................................................. 463
Reading out machine parameters........................................................................................................464
10.12 Preassigned Q parameters................................................................................................................467
Values from the PLC: Q100 to Q107...................................................................................................467
Active tool radius: Q108.......................................................................................................................467
Tool axis: Q109.....................................................................................................................................468
Spindle status: Q110............................................................................................................................ 468
Coolant on/off: Q111............................................................................................................................ 468
Overlap factor: Q112............................................................................................................................ 468
Unit of measurement for dimensions in the program: Q113...............................................................468
Tool length: Q114................................................................................................................................. 469
Coordinates after probing during program run.................................................................................... 469
Deviation between actual value and nominal value during automatic tool measurement with, for
example, the TT 160............................................................................................................................469
Tilting the working plane with spatial (workpiece) angles instead of spindle head angles: Coordinates
for rotary axes calculated by the control............................................................................................. 469
Measurement results from touch probe cycles.................................................................................. 470
Checking the setup situation: Q601.....................................................................................................471
10.13 Programming examples.................................................................................................................... 472
Example: Ellipse................................................................................................................................... 472
Example: Concave cylinder machined with spherical cutter................................................................474
Example: Convex sphere machined with end mill...............................................................................476