HEIDENHAIN TNC 640 (34059x-02) User Manual
Page 29
TNC 640 | User's Manual
HEIDENHAIN Conversational Programming | 5/2013
29
9.9
Accessing tables with SQL commands............................................................................................. 311
Introduction.............................................................................................................................................311
A transaction.......................................................................................................................................... 312
Programming SQL commands...............................................................................................................314
Overview of the soft keys..................................................................................................................... 314
SQL BIND...............................................................................................................................................315
SQL SELECT.......................................................................................................................................... 316
SQL FETCH............................................................................................................................................ 318
SQL UPDATE..........................................................................................................................................319
SQL INSERT........................................................................................................................................... 319
SQL COMMIT........................................................................................................................................ 320
SQL ROLLBACK..................................................................................................................................... 320
9.10
Entering formulas directly................................................................................................................... 321
Entering formulas................................................................................................................................... 321
Rules for formulas..................................................................................................................................323
Programming example........................................................................................................................... 324
9.11
String parameters................................................................................................................................ 325
String processing functions................................................................................................................... 325
Assigning string parameters.................................................................................................................. 326
Chain-linking string parameters..............................................................................................................326
Converting a numerical value to a string parameter..............................................................................327
Copying a substring from a string parameter........................................................................................ 328
Converting a string parameter to a numerical value..............................................................................329
Checking a string parameter.................................................................................................................. 330
Finding the length of a string parameter............................................................................................... 331
Comparing alphabetic sequence............................................................................................................ 332
Reading machine parameters.................................................................................................................333