HEIDENHAIN TNC 320 (77185x-01) - Manual (Page 29)

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