Programming Q Parameters | Accessing tables with SQL commands
10
434
HEIDENHAIN | TNC 620 | Conversational Programming User's Manual | 10/2017
SQL UPDATE
Example: transferring row number in the Q parameter
11 SQL BIND Q881 "TAB_EXAMPLE.MESS_NR"
12 SQL BIND Q882 "TAB_EXAMPLE.MESS_X"
13 SQL BIND Q883 "TAB_EXAMPLE.MESS_Y"
14 SQL BIND Q884 "TAB_EXAMPLE.MESS_Z"
. . .
20 SQL Q5 "SELECT MESS_NR,MESS_X,MESS_Y,MESS_Z FROM
TAB_EXAMPLE"
. . .
30 SQL FETCH Q1 HANDLE Q5 INDEX+Q2
Example: programming the row number directly
. . .
40 SQL UPDATE Q1 HANDLE Q5 INDEX5
SQL UPDATE
changes a row in the
result set
(intermediate
memory). The new values of the individual cells are copied from
the bound Q parameters. The transaction is defined via the
HANDLE
to be specified; the row is defined via the
INDEX
. The
existing row in the
result set
is completely overwritten.
SQL UPDATE
takes all columns into consideration that were
specified with the
SELECT
instruction (SQL command
SQL
EXECUTE
).
Parameter No. for result
(return value for the
control):
0
successful transaction
1
successful transaction
Database: SQL access ID
: Define Q parameters
for the
HANDLE
(for identifying the transaction)
Database: Index for SQL result
: Row number
within the
result set
Program the row number directly
Program the Q parameter containing the
index
The row (n=0) is assigned a value if none is
specified
Содержание TNC 620 E
Страница 4: ......
Страница 5: ...Fundamentals...
Страница 34: ...Contents 34 HEIDENHAIN TNC 620 Conversational Programming User s Manual 10 2017...
Страница 63: ...1 First Steps with the TNC 620...
Страница 86: ......
Страница 87: ...2 Introduction...
Страница 123: ...3 Operating the Touchscreen...
Страница 139: ...4 Fundamentals File Management...
Страница 199: ...5 Programming Aids...
Страница 228: ......
Страница 229: ...6 Tools...
Страница 271: ...7 Programming Contours...
Страница 323: ...8 Data Transfer from CAD Files...
Страница 344: ......
Страница 345: ...9 Subprograms and Program Section Repeats...
Страница 364: ......
Страница 365: ...10 Programming Q Parameters...
Страница 467: ...11 Miscellaneous Functions...
Страница 489: ...12 Special Functions...
Страница 532: ......
Страница 533: ...13 Multiple Axis Machining...
Страница 596: ......
Страница 597: ...14 Pallet Management...
Страница 610: ......
Страница 611: ...15 Batch Process Manager...
Страница 619: ...16 Manual Operation and Setup...
Страница 693: ...17 Positioning with Manual Data Input...
Страница 698: ......
Страница 699: ...18 Test Run and Program Run...
Страница 737: ...19 MOD Functions...
Страница 774: ......
Страница 775: ...20 Tables and Overviews...
Страница 839: ...HEIDENHAIN TNC 620 Conversational Programming User s Manual 10 2017 839 To the datum table 661 Z ZIP archive 189...