HEIDENHAIN TNC 128 (77184x-02) - Manual (Page 23)

TNC 128 | User's Manual HEIDENHAIN Conversational Programming | 5/2014
23
8.9 Accessing tables with SQL commands............................................................................................ 222
Introduction........................................................................................................................................... 222
A transaction......................................................................................................................................... 223
Programming SQL commands..............................................................................................................225
Overview of the soft keys.................................................................................................................... 225
SQL BIND..............................................................................................................................................226
SQL SELECT......................................................................................................................................... 227
SQL FETCH........................................................................................................................................... 229
SQL UPDATE.........................................................................................................................................230
SQL INSERT.......................................................................................................................................... 230
SQL COMMIT....................................................................................................................................... 231
SQL ROLLBACK.................................................................................................................................... 231
8.10 Entering formulas directly.................................................................................................................. 232
Entering formulas.................................................................................................................................. 232
Rules for formulas.................................................................................................................................234
Programming example.......................................................................................................................... 235
8.11 String parameters............................................................................................................................... 236
String processing functions.................................................................................................................. 236
Assigning string parameters................................................................................................................. 237
Chain-linking string parameters.............................................................................................................237
Converting a numerical value to a string parameter.............................................................................238
Copying a substring from a string parameter.......................................................................................239
Converting a string parameter to a numerical value.............................................................................240
Checking a string parameter.................................................................................................................241
Finding the length of a string parameter..............................................................................................242
Comparing alphabetic sequence...........................................................................................................243
Reading machine parameters............................................................................................................... 244