
Programming Q Parameters | Accessing tables with SQL commands
10
442
HEIDENHAIN | TNC 640 | Conversational Programming User's Manual | 10/2017
Example: table name defined with path and file name
. . .
20 SQL Q5 "SELECT Meas_No,Meas_X,Meas_Y, Meas_Z FROM ’V:
\table\Tab_Example’ WHERE Meas_No<20"
Parameter No. for result
(return value for the
control):
0
successful read operation
1
faulty read operation
Database: SQL command text
: programming
SQL instruction
SELECT
with the table column(s) to be
transferred (separate multiple columns with
,
)
FROM
with a table’s synonym or path (place
the path in single quotation marks)
WHERE
(optional) with column names,
condition, and comparison value (Q
parameters after
:
in single quotation marks)
ORDER BY
(optional) with column names and
type of ordering (
ASC
for ascending,
DESC
for
descending order)
FOR UPDATE
(optional) to lock write access to
the selected row for other processes
Conditions for
WHERE
entries
Condition
Programming
Equals
= ==
Not equal to
!= <>
Less than
<
Less than or equal to
<=
Greater than
>
Greater than or equal to
>=
empty
IS NULL
Not empty
IS NOT NULL
Linking multiple conditions:
Logical AND
AND
Logical OR
OR
Summary of Contents for TNC 640
Page 4: ......
Page 5: ...Fundamentals ...
Page 36: ...Contents 36 HEIDENHAIN TNC 640 Conversational Programming User s Manual 10 2017 ...
Page 67: ...1 First Steps with the TNC 640 ...
Page 90: ......
Page 91: ...2 Introduction ...
Page 130: ......
Page 131: ...3 Operating the Touchscreen ...
Page 144: ......
Page 145: ...4 Fundamentals File Management ...
Page 206: ......
Page 207: ...5 Programming Aids ...
Page 236: ......
Page 237: ...6 Tools ...
Page 281: ...7 Programming Contours ...
Page 333: ...8 Data Transfer from CAD Files ...
Page 355: ...9 Subprograms and Program Section Repeats ...
Page 374: ......
Page 375: ...10 Programming Q Parameters ...
Page 478: ......
Page 479: ...11 Miscellaneous Functions ...
Page 501: ...12 Special Functions ...
Page 584: ......
Page 585: ...13 Multiple Axis Machining ...
Page 650: ......
Page 651: ...14 Pallet Management ...
Page 664: ......
Page 665: ...15 Batch Process Manager ...
Page 673: ...16 Turning ...
Page 713: ...17 Manual Operation and Setup ...
Page 797: ...18 Positioning with Manual Data Input ...
Page 803: ...19 Test Run and Program Run ...
Page 843: ...20 MOD Functions ...
Page 881: ...21 Tables and Overviews ...