HEIDENHAIN TNC 640 (34059x-04) - Manual (Page 31)

TNC 640 | User's Manual
HEIDENHAIN Conversational Programming | 3/2014
31
9.9 Accessing tables with SQL commands............................................................................................ 317
Introduction........................................................................................................................................... 317
A transaction......................................................................................................................................... 318
Programming SQL commands..............................................................................................................320
Overview of the soft keys.................................................................................................................... 320
SQL BIND..............................................................................................................................................321
SQL SELECT......................................................................................................................................... 322
SQL FETCH........................................................................................................................................... 324
SQL UPDATE.........................................................................................................................................325
SQL INSERT..........................................................................................................................................325
SQL COMMIT....................................................................................................................................... 326
SQL ROLLBACK.................................................................................................................................... 326
9.10 Entering formulas directly..................................................................................................................327
Entering formulas..................................................................................................................................327
Rules for formulas.................................................................................................................................329
Programming example.......................................................................................................................... 330
9.11 String parameters............................................................................................................................... 331
String processing functions.................................................................................................................. 331
Assigning string parameters................................................................................................................. 332
Chain-linking string parameters.............................................................................................................332
Converting a numerical value to a string parameter.............................................................................333
Copying a substring from a string parameter.......................................................................................334
Converting a string parameter to a numerical value.............................................................................335
Checking a string parameter.................................................................................................................336
Finding the length of a string parameter..............................................................................................337
Comparing alphabetic sequence...........................................................................................................338
Reading machine parameters............................................................................................................... 339