Heidenhain TNC 620 (81760x-01) ISO programming User Manual Page 279
- Page / 584
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
Accessing tables with SQL commands 9.8
9
TNC 620 | User's Manual for DIN/ISO Programming | 3/2014
279
9.8 Accessing tables with SQL commands
Introduction
Accessing of tables is programmed on the TNC with SQL
commands in transactions. A transaction consists of multiple SQL
commands that guarantee an orderly execution of the table entries.
Tables are configured by the machine manufacturer.
Names and designations required as parameters for
SQL commands are also specified.
The following terms are used:
Table: A table consists of x columns and y rows. It is saved as
a file in the File Manager of the TNC, and is addressed with the
path and file name (=table name). Synonyms can also be used
for addressing, as an alternative to the path and file name.
Columns: The number and names of the columns are specified
when configuring the table. In some SQL commands the
column name is used for addressing.
Rows: The number of rows is variable. You can insert new
rows. There are no row numbers or other designators. However,
you can select rows based on the contents of a column. Rows
can only be deleted in the table editor, not by an NC program.
Cell: The part of a column in a row.
Table entry: Content of a cell.
Result set: During a transaction, the selected columns and
rows are managed in the result set. You can view the result set
as a sort of "intermediate memory," which temporarily assumes
the set of selected columns and rows. Result set
Synonym: This term defines a name used for a table instead of
its path and file name. Synonyms are specified by the machine
manufacturer in the configuration data.
- User’s Manual 1
- DIN/ISO Programming 1
- Controls of the TNC 2
- About this manual 6
- Fundamentals 10
- Intended place of operation 11
- Legal information 11
- Contents 17
- First Steps with 47
- First Steps with the TNC 620 48
- 1.1 Overview 48
- 1.2 Machine switch-on 48
- The most important TNC keys 49
- Defining a workpiece blank 51
- Programming a simple contour 53
- Setting up tools 1.5 61
- 1.5 Setting up tools 61
- 1.6 Workpiece setup 64
- Workpiece setup 1.6 65
- 1.7 Running the first program 66
- 2.1 The TNC 620 68
- Display screen 69
- Modes of Operation 2.3 71
- 2.3 Modes of Operation 71
- Status displays 2.4 73
- 2.4 Status displays 73
- 2.5 Window Manager 80
- Window Manager 2.5 81
- 2.6 SELinux security software 82
- Handwheels 84
- Fundamentals, file 85
- 3.1 Fundamentals 86
- Fundamentals 3.1 87
- Block number 91
- Path function 91
- Define the blank: G30/G31 92
- Opening a new part program 94
- Actual position capture 96
- Editing a program 97
- The TNC search function 100
- Data Backup 104
- Directories 105
- Calling the file manager 107
- Copying a single file 109
- Creating a new directory 109
- Creating a new file 109
- Copying a table 111
- Copying a directory 111
- Deleting a file 113
- Deleting a directory 113
- Tagging files 114
- Renaming a file 115
- Sorting files 115
- Additional functions 116
- The TNC in a network 124
- USB devices on the TNC 125
- Programming: 127
- Programming aids 127
- 4.1 Screen keyboard 128
- Adding comments 4.2 129
- 4.2 Adding comments 129
- Display of NC Programs 4.3 131
- 4.3 Display of NC Programs 131
- 4.4 Structuring programs 132
- Calculator 4.5 133
- 4.5 Calculator 133
- 4.6 Cutting data calculator 136
- Cutting data calculator 4.6 137
- Programming graphics 4.7 139
- 4.7 Programming graphics 139
- 4.8 Error messages 142
- Error messages 4.8 143
- Application 148
- Working with the TNCguide 149
- Programming: Tools 156
- Spindle speed S 157
- 5.2 Tool data 158
- Tool data 5.2 159
- Tool compensation 5.3 179
- 5.3 Tool compensation 179
- Programming 183
- 6.1 Tool movements 184
- N50 G00 X+100 * 185
- N50 G00 X+70 Y+50 * 185
- N50 G01 X+80 Y+0 Z-10 * 186
- Starting point and end point 188
- N50 G00 G40 X+60 Y+70 * 189
- N60 Z+250 * 189
- Overview of path functions 197
- Programming path functions 197
- N80 G91 X+20 Y-15 * 198
- N90 G90 X+60 G91 Y-10 * 198
- N80 X+40 G91 Y+5 * 199
- N90 G24 R12 F250 * 199
- N100 G91 X+5 G90 Y+0 * 199
- Corner rounding G25 200
- Circle center I, J 201
- N50 I+25 J+25 * 202
- N70 G03 X+45 Y+25 * 202
- Example NC blocks 204
- N80 X+25 Y+30 * 205
- N90 G06 X+45 Y+20 * 205
- G01 Y+0 * 205
- Cartesian coordinates 206
- Overview 209
- N120 I+40 J+25 * 213
- N130 G01 Z+0 F100 M3 * 213
- N140 G11 G41 R+3 H+270 * 213
- N150 G12 G91 H-1800 Z+5 * 213
- Example: Helix 215
- Data transfer from 217
- DXF files or plain 217
- Opening a DXF file 219
- Basic settings 220
- Setting layers 222
- Defining the datum 223
- Subprograms and 235
- Section Repeats 236
- Subprograms 8.2 237
- 8.2 Subprograms 237
- Program-section repeats 8.3 239
- 8.3 Program-section repeats 239
- Operating sequence 241
- Programming notes 241
- Nesting 8.5 243
- 8.5 Nesting 243
- Programming examples 8.6 247
- 8.6 Programming examples 247
- Programming: Q 251
- Parameters 251
- Programming: Q Parameters 252
- 9.3 Describing contours with 256
- N17 D00 Q5 P01 +10 * 257
- N17 D03 Q12 P01 +Q5 P02 +7 * 257
- Unconditional jumps 259
- Programming if-then decisions 259
- 9.7 Additional functions 262
- Additional functions 9.7 263
- Introduction 279
- SQL BIND 283
- SQL UPDATE 287
- SQL INSERT 287
- Entering formulas 289
- Rules for formulas 291
- String parameters 9.10 293
- 9.10 String parameters 293
- Programming examples 9.12 309
- 9.12 Programming examples 309
- Miscellaneous 315
- N110 X ... G91 Y ... M98 * 322
- N120 X+ ... * 322
- Deleting basic rotation: M143 332
- Rounding corners: M197 334
- Special functions 335
- Program defaults menu 337
- Activating/deactivating ACC 340
- 11.4 Creating Text Files 342
- Creating Text Files 11.4 343
- 11.5 Freely definable tables 346
- Freely definable tables 11.5 347
- Multiple Axis 353
- Machining 353
- Defining the PLANE function 357
- Position display 357
- Resetting the PLANE function 358
- PLANE SPATIAL 359
- +45 360
- PLANE PROJECTED 361
- PLANE EULER 362
- PLANE VECTOR 364
- +0 P3Y+41 P3Z+32.5 367
- 5 PLANE RELATIV SPB-45 368
- PLANE AXIAL (FCL 3 function) 369
- 5 PLANE AXIAL B-45 370
- Function 376
- M116 (software option 1) 377
- 360°: M94 379
- Selecting tilting axes: M138 383
- M144 (software option 2) 384
- Defining the TCPM FUNCTION 385
- Resetting the TCPM FUNCTION 389
- Pallet editor 391
- Programming: Pallet editor 392
- Manual operation 397
- Manual operation and setup 398
- 14.1 Switch-on, switch-off 398
- Switch-on, switch-off 14.1 399
- Moving the machine axes 14.2 401
- 14.2 Moving the machine axes 401
- Explanation of terms 415
- Preparation 419
- Function software option) 426
- Selecting touch probe cycles 429
- Displaying calibration values 437
- Identifying basic rotation 439
- Datum setting in any axis 441
- Software Option) 442
- Application, function 451
- Positioning with 457
- Manual Data Input 457
- Test run and 463
- Test run and program run 464
- Plan view 467
- Projection in three planes 467
- Repeating graphic simulation 471
- Tool display 471
- Test Run 16.4 475
- 16.4 Test Run 475
- Program run 16.5 477
- 16.5 Program run 477
- 16.6 Automatic program start 488
- Optional block skip 16.7 489
- 16.7 Optional block skip 489
- MOD functions 491
- 17.1 MOD function 492
- MOD function 17.1 493
- 17.2 Graphic settings 494
- Machine settings 17.3 495
- 17.3 Machine settings 495
- System settings 17.4 497
- 17.4 System settings 497
- 17.5 Position Display Types 498
- 17.6 Unit of Measurement 499
- 17.8 Software numbers 500
- 17.9 Entering the code number 500
- Setting the RS-232 interface 501
- Data transfer software 505
- Ethernet interface 17.11 507
- 17.11 Ethernet interface 507
- Firewall 17.12 513
- 17.12 Firewall 513
- Tables and 519
- Tables and overviews 520
- 18.3 Technical Information 534
- Technical Information 18.3 535
- 18.4 Overview tables 542
- Overview tables 18.4 543
- 530 compared 545
- Comparison: User functions 547
- Touch probes from HEIDENHAIN 584
Related products and manuals for Equipment Heidenhain TNC 620 (81760x-01) ISO programming
(593 pages)
(591 pages)
(604 pages)
(608 pages)
(656 pages)
(656 pages)© 2020, manymanuals.com. All rights reserved. | 0.231 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals