HEIDENHAIN TNC 620 (81760x-02) - Manual (Page 33)

TNC 620 | User's Manual
HEIDENHAIN Conversational Programming | 2/2015 33
9.9 Accessing tables with SQL commands............................................................................................ 327
Introduction........................................................................................................................................... 327
A transaction......................................................................................................................................... 328
Programming SQL commands..............................................................................................................330
Overview of the soft keys.................................................................................................................... 330
SQL BIND..............................................................................................................................................331
SQL SELECT......................................................................................................................................... 332
SQL FETCH........................................................................................................................................... 334
SQL UPDATE.........................................................................................................................................335
SQL INSERT..........................................................................................................................................335
SQL COMMIT....................................................................................................................................... 336
SQL ROLLBACK.................................................................................................................................... 336
9.10 Entering formulas directly.................................................................................................................. 337
Entering formulas..................................................................................................................................337
Rules for formulas.................................................................................................................................339
Programming example.......................................................................................................................... 340
9.11 String parameters............................................................................................................................... 341
String processing functions.................................................................................................................. 341
Assigning string parameters................................................................................................................. 342
Chain-linking string parameters.............................................................................................................342
Converting a numerical value to a string parameter.............................................................................343
Copying a substring from a string parameter.......................................................................................344
Converting a string parameter to a numerical value.............................................................................345
Checking a string parameter.................................................................................................................346
Finding the length of a string parameter..............................................................................................347
Comparing alphabetic sequence...........................................................................................................348
Reading out machine parameters......................................................................................................... 349