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