HEIDENHAIN TNC 620 Programming Station - Page 348

Programming Qparameters | Accessing tables with SQL statements
9
Comparison
The results of the following NC programs are identical.
0 BEGIN PGM SQL_READ_WMAT MM
1 SQL Q1800 "CREATE SYNONYM my_table FOR 'TNC:
\table\WMAT.TAB'"
Create synonym
2 SQL BIND QS1800 "my_table.WMAT"
Bind QS parameters
3 SQL QL1 "SELECT WMAT FROM my_table WHERE
NR==3"
Define search
...
...
3 SQL SELECT QS1800 "SELECT WMAT FROM my_table
WHERE NR==3"
Read and save a value
...
For the instructions within the SQL command, you can
likewise use single or combined QS parameters.
If you check the content of a QS parameter in the
additional status indicator (QPARA tab), then you will see
only the first 30 characters and therefore not the entire
content.
...
3 DECLARE STRING QS1 = "SELECT "
4 DECLARE STRING QS2 = "WMAT "
5 DECLARE STRING QS3 = "FROM "
6 DECLARE STRING QS4 = "my_table "
7 DECLARE STRING QS5 = "WHERE "
8 DECLARE STRING QS6 = "NR==3"
9 QS7 = QS1 || QS2 || QS3 || QS4 || QS5 || QS6
10 SQL SELECT QL1 QS7
11 ...
348
HEIDENHAIN | TNC620 | Klartext Programming User's Manual | 01/2022