HEIDENHAIN TNC 620 Programming Station User Manual

Programming Q Parameters | Accessing tables with SQL commands
10
432
HEIDENHAIN | TNC 620 | Conversational Programming User's Manual | 10/2017
Syntax examples
The following examples are listed without context. The NC blocks
are limited exclusively to the possibilities of the SQL command SQL
EXECUTE.
Example
9 SQL Q1800 "CREATE SYNONYM my_table FOR 'TNC:
\table\MILL.TAB'"
Create synonym
9 SQL Q1800 "DROP SYNONYM my_table"
Delete synonym
9 SQL Q1800 "CREATE TABLE my_table (NO,WMAT)"
Create table with the rows NO and WMAT.
9 SQL Q1800 "COPY TABLE my_table TO 'TNC:\table
\MILL2.TAB'"
Copy table
9 SQL Q1800 "RENAME TABLE my_table TO 'TNC:\table
\MILL3.TAB'"
Rename table
9 SQL Q1800 "DROP TABLE my_table"
Delete the table
9 SQL Q1800 "INSERT INTO my_table VALUES
(1,'ENAW',240)"
Insert table row
9 SQL Q1800 "DELETE FROM my_table WHERE NO==3"
Delete table row
9 SQL Q1800 "ALTER TABLE my_table ADD (WMAT2)"
Insert table rows
9 SQL Q1800 "ALTER TABLE my_table DROP (WMAT2)"
Delete table rows
9 SQL Q1800 "RENAME COLUMN my_table (WMAT2) TO
(WMAT3)"
Rename table column

HEIDENHAIN TNC 620 Programming Station Specifications

General

Brand	HEIDENHAIN
Model	TNC 620 Programming Station
Category	Control Systems
Language	English