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

22
10.9 Accessing Tables with SQL Commands ..... 345
Introduction ..... 345
A Transaction ..... 346
Programming SQL commands ..... 348
Overview of the soft keys ..... 348
SQL BIND ..... 349
SQL SELECT ..... 350
SQL FETCH ..... 353
SQL UPDATE ..... 354
SQL INSERT ..... 354
SQL COMMIT ..... 355
SQL ROLLBACK ..... 355
10.10 Entering Formulas Directly ..... 356
Entering formulas ..... 356
Rules for formulas ..... 358
Programming example ..... 359
10.11 Preassigned Q Parameters ..... 360
Values from the PLC: Q100 to Q107 ..... 360
Active tool radius: Q108 ..... 360
Tool axis: Q109 ..... 360
Spindle status: Q110 ..... 361
Coolant on/off: Q111 ..... 361
Overlap factor: Q112 ..... 361
Unit of measurement for dimensions in the program: Q113 ..... 361
Tool length: Q114 ..... 361
Coordinates after probing during program run ..... 362
10.12 String Parameters ..... 363
Working with string parameters ..... 363
Assigning string parameters ..... 363
String processing functions ..... 364
Concatenation of string parameters ..... 364
Exporting machine parameters ..... 365
Converting a numerical value to a string parameter ..... 365
Converting a string parameter to a numerical value ..... 365
Reading a substring from a string parameter ..... 365
Checking a string parameter ..... 366
Reading the length of a string parameter ..... 366
Reading the alphabetic order ..... 366
Reading system strings ..... 366