beautypg.com

HEIDENHAIN TNC 620 (81760x-01) User Manual

Page 31

background image

TNC 620 | User's Manual

HEIDENHAIN Conversational Programming | 3/2014

31

9.9

Accessing tables with SQL commands............................................................................................ 305

Introduction........................................................................................................................................... 305
A transaction......................................................................................................................................... 306
Programming SQL commands..............................................................................................................308
Overview of the soft keys.................................................................................................................... 308
SQL BIND..............................................................................................................................................309
SQL SELECT......................................................................................................................................... 310
SQL FETCH........................................................................................................................................... 312
SQL UPDATE.........................................................................................................................................313
SQL INSERT..........................................................................................................................................313
SQL COMMIT....................................................................................................................................... 314
SQL ROLLBACK.................................................................................................................................... 314

9.10 Entering formulas directly..................................................................................................................315

Entering formulas..................................................................................................................................315
Rules for formulas.................................................................................................................................317
Programming example.......................................................................................................................... 318

9.11 String parameters............................................................................................................................... 319

String processing functions.................................................................................................................. 319
Assigning string parameters................................................................................................................. 320
Chain-linking string parameters.............................................................................................................320
Converting a numerical value to a string parameter.............................................................................321
Copying a substring from a string parameter.......................................................................................322
Converting a string parameter to a numerical value.............................................................................323
Checking a string parameter.................................................................................................................324
Finding the length of a string parameter..............................................................................................325
Comparing alphabetic sequence...........................................................................................................326
Reading machine parameters............................................................................................................... 327