HEIDENHAIN TNC 620 (34056x-04) ISO programming User Manual
Page 27
TNC 620 | User's Manual for DIN/ISO Programming | 5/2013
27
8.8
Accessing tables with SQL commands............................................................................................. 241
Introduction.............................................................................................................................................241
A transaction.......................................................................................................................................... 242
Programming SQL commands...............................................................................................................244
Overview of the soft keys..................................................................................................................... 244
SQL BIND...............................................................................................................................................245
SQL SELECT.......................................................................................................................................... 246
SQL FETCH............................................................................................................................................ 248
SQL UPDATE..........................................................................................................................................249
SQL INSERT........................................................................................................................................... 249
SQL COMMIT........................................................................................................................................ 250
SQL ROLLBACK..................................................................................................................................... 250
8.9
Entering formulas directly................................................................................................................... 251
Entering formulas................................................................................................................................... 251
Rules for formulas..................................................................................................................................253
Programming example........................................................................................................................... 254
8.10
String parameters................................................................................................................................ 255
String processing functions................................................................................................................... 255
Assigning string parameters.................................................................................................................. 256
Chain-linking string parameters..............................................................................................................256
Converting a numerical value to a string parameter..............................................................................257
Copying a substring from a string parameter........................................................................................ 258
Converting a string parameter to a numerical value..............................................................................259
Checking a string parameter.................................................................................................................. 260
Finding the length of a string parameter............................................................................................... 261
Comparing alphabetic sequence............................................................................................................ 262
Reading machine parameters.................................................................................................................263