HEIDENHAIN TNC 620 (73498x-02) - Manual (Page 29)

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