HEIDENHAIN TNC 620 (81760x-01) - Manual (Page 31)

TNC 620 | User's Manual
HEIDENHAIN Conversational Programming | 3/2014
31
9.9 Accessing tables with SQL commands............................................................................................ 305
Introduction........................................................................................................................................... 305
A transaction......................................................................................................................................... 306
Programming SQL commands..............................................................................................................308
Overview of the soft keys.................................................................................................................... 308
SQL BIND..............................................................................................................................................309
SQL SELECT......................................................................................................................................... 310
SQL FETCH........................................................................................................................................... 312
SQL UPDATE.........................................................................................................................................313
SQL INSERT..........................................................................................................................................313
SQL COMMIT....................................................................................................................................... 314
SQL ROLLBACK.................................................................................................................................... 314
9.10 Entering formulas directly..................................................................................................................315
Entering formulas..................................................................................................................................315
Rules for formulas.................................................................................................................................317
Programming example.......................................................................................................................... 318
9.11 String parameters............................................................................................................................... 319
String processing functions.................................................................................................................. 319
Assigning string parameters................................................................................................................. 320
Chain-linking string parameters.............................................................................................................320
Converting a numerical value to a string parameter.............................................................................321
Copying a substring from a string parameter.......................................................................................322
Converting a string parameter to a numerical value.............................................................................323
Checking a string parameter.................................................................................................................324
Finding the length of a string parameter..............................................................................................325
Comparing alphabetic sequence...........................................................................................................326
Reading machine parameters............................................................................................................... 327