Programming Q Parameters | Accessing tables with SQL commands
10
436
HEIDENHAIN | TNC 620 | Conversational Programming User's Manual | 10/2017
SQL COMMIT
Example
11 SQL BIND Q881 "Tab_Example.Meas_No"
12 SQL BIND Q882 "Tab_Example.Meas_X"
13 SQL BIND Q883 "Tab_Example.Meas_Y"
14 SQL BIND Q884 "Tab_Example.Meas_Z"
. . .
20 SQL Q5 "SELECT Meas_no,Meas_X,Meas_Y, Meas_Z FROM
Tab_Example"
. . .
30 SQL FETCH Q1 HANDLE Q5 INDEX+Q2
. . .
40 SQL UPDATE Q1 HANDLE Q5 INDEX+Q2
. . .
50 SQL COMMIT Q1 HANDLE Q5
SQL COMMIT
simultaneously transfers all of the rows that have
been changed and added in a transaction back into the table. The
transaction is defined via the
HANDLE
to be specified. A lock that
was set with
SELECT...FOR UPDATE
is canceled.
The
HANDLE
(process) assigned with the instruction
SQL SELECT
becomes invalid.
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)
Содержание 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...