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