HEIDENHAIN TNC 620 (73498x-02) ISO programming User Manual
Page 28
Contents
28
TNC 620 | User's Manual for DIN/ISO Programming | 5/2013
9.8
Accessing tables with SQL commands............................................................................................. 265
Introduction.............................................................................................................................................265
A transaction.......................................................................................................................................... 266
Programming SQL commands...............................................................................................................268
Overview of the soft keys..................................................................................................................... 268
SQL BIND...............................................................................................................................................269
SQL SELECT.......................................................................................................................................... 270
SQL FETCH............................................................................................................................................ 272
SQL UPDATE..........................................................................................................................................273
SQL INSERT........................................................................................................................................... 273
SQL COMMIT........................................................................................................................................ 274
SQL ROLLBACK..................................................................................................................................... 274
9.9
Entering formulas directly................................................................................................................... 275
Entering formulas................................................................................................................................... 275
Rules for formulas..................................................................................................................................277
Programming example........................................................................................................................... 278
9.10
String parameters................................................................................................................................ 279
String processing functions................................................................................................................... 279
Assigning string parameters.................................................................................................................. 280
Chain-linking string parameters..............................................................................................................280
Converting a numerical value to a string parameter..............................................................................281
Copying a substring from a string parameter........................................................................................ 282
Converting a string parameter to a numerical value..............................................................................283
Checking a string parameter.................................................................................................................. 284
Finding the length of a string parameter............................................................................................... 285
Comparing alphabetic sequence............................................................................................................ 286
Reading machine parameters.................................................................................................................287