
Programming Q Parameters | Accessing tables with SQL commands
10
HEIDENHAIN | TNC 640 | Conversational Programming User's Manual | 10/2017
447
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 640
Страница 4: ......
Страница 5: ...Fundamentals ...
Страница 36: ...Contents 36 HEIDENHAIN TNC 640 Conversational Programming User s Manual 10 2017 ...
Страница 67: ...1 First Steps with the TNC 640 ...
Страница 90: ......
Страница 91: ...2 Introduction ...
Страница 130: ......
Страница 131: ...3 Operating the Touchscreen ...
Страница 144: ......
Страница 145: ...4 Fundamentals File Management ...
Страница 206: ......
Страница 207: ...5 Programming Aids ...
Страница 236: ......
Страница 237: ...6 Tools ...
Страница 281: ...7 Programming Contours ...
Страница 333: ...8 Data Transfer from CAD Files ...
Страница 355: ...9 Subprograms and Program Section Repeats ...
Страница 374: ......
Страница 375: ...10 Programming Q Parameters ...
Страница 478: ......
Страница 479: ...11 Miscellaneous Functions ...
Страница 501: ...12 Special Functions ...
Страница 584: ......
Страница 585: ...13 Multiple Axis Machining ...
Страница 650: ......
Страница 651: ...14 Pallet Management ...
Страница 664: ......
Страница 665: ...15 Batch Process Manager ...
Страница 673: ...16 Turning ...
Страница 713: ...17 Manual Operation and Setup ...
Страница 797: ...18 Positioning with Manual Data Input ...
Страница 803: ...19 Test Run and Program Run ...
Страница 843: ...20 MOD Functions ...
Страница 881: ...21 Tables and Overviews ...