HEIDENHAIN TNC 320 (77185x-01) ISO programming User Manual
Page 29
TNC 320 | User's Manual for DIN/ISO Programming | 3/2014
29
9.8
Accessing tables with SQL commands............................................................................................ 275
Introduction........................................................................................................................................... 275
A transaction......................................................................................................................................... 276
Programming SQL commands..............................................................................................................278
Overview of the soft keys.................................................................................................................... 278
SQL BIND..............................................................................................................................................279
SQL SELECT......................................................................................................................................... 280
SQL FETCH........................................................................................................................................... 282
SQL UPDATE.........................................................................................................................................283
SQL INSERT..........................................................................................................................................283
SQL COMMIT....................................................................................................................................... 284
SQL ROLLBACK.................................................................................................................................... 284
9.9
Entering formulas directly..................................................................................................................285
Entering formulas..................................................................................................................................285
Rules for formulas.................................................................................................................................287
Programming example.......................................................................................................................... 288
9.10 String parameters............................................................................................................................... 289
String processing functions.................................................................................................................. 289
Assigning string parameters................................................................................................................. 290
Chain-linking string parameters.............................................................................................................290
Converting a numerical value to a string parameter.............................................................................291
Copying a substring from a string parameter.......................................................................................292
Converting a string parameter to a numerical value.............................................................................293
Checking a string parameter.................................................................................................................294
Finding the length of a string parameter..............................................................................................295
Comparing alphabetic sequence...........................................................................................................296
Reading machine parameters............................................................................................................... 297