HEIDENHAIN TNC 640 (34059x-04) ISO programming User Manual
Page 31
TNC 640 | User's Manual for DIN/ISO Programming | 3/2014
31
9.8
Accessing tables with SQL commands............................................................................................ 291
Introduction........................................................................................................................................... 291
A transaction......................................................................................................................................... 292
Programming SQL commands..............................................................................................................294
Overview of the soft keys.................................................................................................................... 294
SQL BIND..............................................................................................................................................295
SQL SELECT......................................................................................................................................... 296
SQL FETCH........................................................................................................................................... 298
SQL UPDATE.........................................................................................................................................299
SQL INSERT..........................................................................................................................................299
SQL COMMIT....................................................................................................................................... 300
SQL ROLLBACK.................................................................................................................................... 300
9.9
Entering formulas directly..................................................................................................................301
Entering formulas..................................................................................................................................301
Rules for formulas.................................................................................................................................303
Programming example.......................................................................................................................... 304
9.10 String parameters............................................................................................................................... 305
String processing functions.................................................................................................................. 305
Assigning string parameters................................................................................................................. 306
Chain-linking string parameters.............................................................................................................306
Converting a numerical value to a string parameter.............................................................................307
Copying a substring from a string parameter.......................................................................................308
Converting a string parameter to a numerical value.............................................................................309
Checking a string parameter.................................................................................................................310
Finding the length of a string parameter..............................................................................................311
Comparing alphabetic sequence...........................................................................................................312
Reading machine parameters............................................................................................................... 313