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