HEIDENHAIN TNC 620 Programming Station

Programming Qparameters | Accessing tables with SQL statements
9
Step Explanation
6 Remove
binding
The binding between table columns and QS parameters is removed (release of necessary
resources)
7 Delete synonym The synonym is deleted (release of necessary resources)
Synonyms are an alternative only to the required absolute
paths. Relative path entries are not possible.
The following NC program shows the entry of an absolute path.
Example: Use an absolute path
0 BEGIN PGM SQL_READ_WMAT_2 MM
1 SQL BIND QS 1800 "'TNC:\table\WMAT.TAB'.WMAT"
Bind QS parameters
2 SQL QL1 "SELECT WMAT FROM 'TNC:\table\WMAT.TAB'
WHERE NR ==3"
Define search
3 SQL FETCH Q1900 HANDLE QL1
Execute search
4 SQL ROLLBACK Q1900 HANDLE QL1
Complete transaction
5 SQL BIND QS 1800
Remove parameter binding
6 END PGM SQL_READ_WMAT_2 MM
350
HEIDENHAIN | TNC620 | Klartext Programming User's Manual | 01/2022