HEIDENHAIN TNC 640, User Manual, Page: 443 / 948

Programming Q Parameters | Accessing tables with SQL commands
10
HEIDENHAIN | TNC 640 | Conversational Programming User's Manual | 10/2017
443
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