Heidenhain TNC 620 (81760x-01) ISO programming User Manual Page 287
- 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
287
SQL UPDATE
SQL UPDATE transfers the data prepared in the Q parameters into the
row of the result set addressed with INDEX. The existing row in the
result set is completely overwritten.
SQL UPDATE takes into account all columns entered in the "Select"
command.
Parameter no. for result: Q parameter, in which
the SQL server has reported the result:
0: No error occurred
1: Error occurred (incorrect handle, index too large,
value outside of value range or incorrect data
format)
Database: SQL access ID: Q parameter with the
handle for identifying the result set (also see SQL
SELECT).
Database: Index to SQL result: Line number within
the result set. The table entries prepared in the Q
parameters are written to this row. If you do not
enter an index, the first row is written to (n=0).
Either enter the row number directly or program the
Q parameter containing the index
Row number is programmed directly
. . .
40 SQL UPDATEQ1 HANDLE Q5 INDEX5
SQL INSERT
SQL INSERT generates a new row in the result set and transfers the
data prepared in the Q parameters into the new row.
SQL INSERT takes into account all columns entered in the "Select"
command. Table columns not entered in the "Select" command are
filled with default values.
Parameter no. for result: Q parameter, in which
the SQL server has reported the result:
0: No error occurred
1: Error occurred (incorrect handle, value outside of
value range or incorrect data format)
Database: SQL access ID: Q parameter with the
handle for identifying the result set (also see SQL
SELECT).
Row number is transferred in a Q
parameter
11SQL BIND Q881
"TAB_EXAMPLE.MEAS_NO"
12SQL BIND Q882
"TAB_EXAMPLE.MEAS_X"
13SQL BIND Q883
"TAB_EXAMPLE.MEAS_Y"
14SQL BIND Q884
"TAB_EXAMPLE.MEAS_Z"
. . .
20SQL Q5 "SELECT
MEAS_NO,MEAS_X,MEAS_Y, MEAS_Z
FROM TAB_EXAMPLE"
. . .
40 SQL INSERTQ1 HANDLE Q5
- 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.851 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals