HEIDENHAIN TNC 640 (34059x-02) ISO programming User Manual
Page 28
Contents
28
TNC 640 | User's Manual for DIN/ISO Programming | 5/2013
9.8
Accessing tables with SQL commands............................................................................................. 277
Introduction.............................................................................................................................................277
A transaction.......................................................................................................................................... 278
Programming SQL commands...............................................................................................................280
Overview of the soft keys..................................................................................................................... 280
SQL BIND...............................................................................................................................................281
SQL SELECT.......................................................................................................................................... 282
SQL FETCH............................................................................................................................................ 284
SQL UPDATE..........................................................................................................................................285
SQL INSERT........................................................................................................................................... 285
SQL COMMIT........................................................................................................................................ 286
SQL ROLLBACK..................................................................................................................................... 286
9.9
Entering formulas directly................................................................................................................... 287
Entering formulas................................................................................................................................... 287
Rules for formulas..................................................................................................................................289
Programming example........................................................................................................................... 290
9.10
String parameters................................................................................................................................ 291
String processing functions................................................................................................................... 291
Assigning string parameters.................................................................................................................. 292
Chain-linking string parameters..............................................................................................................292
Converting a numerical value to a string parameter..............................................................................293
Copying a substring from a string parameter........................................................................................294
Converting a string parameter to a numerical value..............................................................................295
Checking a string parameter..................................................................................................................296
Finding the length of a string parameter...............................................................................................297
Comparing alphabetic sequence............................................................................................................298
Reading machine parameters.................................................................................................................299