TNC 320 | User's Manual
HEIDENHAIN Conversational Programming | 3/2014
29
9.9
Accessing tables with SQL commands............................................................................................ 301
Introduction........................................................................................................................................... 301
A transaction......................................................................................................................................... 302
Programming SQL commands..............................................................................................................304
Overview of the soft keys.................................................................................................................... 304
SQL BIND..............................................................................................................................................305
SQL SELECT......................................................................................................................................... 306
SQL FETCH........................................................................................................................................... 308
SQL UPDATE.........................................................................................................................................309
SQL INSERT..........................................................................................................................................309
SQL COMMIT....................................................................................................................................... 310
SQL ROLLBACK.................................................................................................................................... 310
9.10 Entering formulas directly..................................................................................................................311
Entering formulas..................................................................................................................................311
Rules for formulas.................................................................................................................................313
Programming example.......................................................................................................................... 314
9.11 String parameters............................................................................................................................... 315
String processing functions.................................................................................................................. 315
Assigning string parameters................................................................................................................. 316
Chain-linking string parameters.............................................................................................................316
Converting a numerical value to a string parameter.............................................................................317
Copying a substring from a string parameter.......................................................................................318
Converting a string parameter to a numerical value.............................................................................319
Checking a string parameter.................................................................................................................320
Finding the length of a string parameter..............................................................................................321
Comparing alphabetic sequence...........................................................................................................322
Reading machine parameters............................................................................................................... 323
Summary of Contents for TNC 320
Page 4: ...Controls of the TNC 4 TNC 320 User s Manual HEIDENHAIN Conversational Programming 3 2014 ...
Page 5: ...Fundamentals ...
Page 16: ...Contents 16 TNC 320 User s Manual HEIDENHAIN Conversational Programming 3 2014 ...
Page 43: ...1 First Steps with the TNC 320 ...
Page 63: ...2 Introduction ...
Page 81: ...3 Programming Fundamentals file management ...
Page 124: ......
Page 125: ...4 Programming Programming aids ...
Page 152: ......
Page 153: ...5 Programming Tools ...
Page 180: ......
Page 181: ...6 Programming Programming contours ...
Page 232: ......
Page 233: ...7 Programming Data transfer from DXF files or plain language contours ...
Page 251: ...8 Programming Subprograms and program section repeats ...
Page 267: ...9 Programming Q Parameters ...
Page 337: ...10 Programming Miscellaneous functions ...
Page 357: ...11 Programming Special functions ...
Page 379: ...12 Programming Multiple Axis Machining ...
Page 406: ......
Page 407: ...13 Manual operation and setup ...
Page 462: ......
Page 463: ...14 Positioning with Manual Data Input ...
Page 468: ......
Page 469: ...15 Test run and program run ...
Page 497: ...16 MOD functions ...
Page 525: ...17 Tables and overviews ...