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

Programming Q Parameters | Accessing tables with SQL commands
10
438
HEIDENHAIN | TNC 640 | Conversational Programming User's Manual | 10/2017
Overview of instructions
The following so-called SQL instructions are used in the SQL
command
SQL EXECUTE
.
Further information: "SQL EXECUTE", page 441
Instruction Function
SELECT
Select data
CREATE
SYNONYM
Create synonym (replace long path names
with short names)
DROP SYNONYM
Delete synonym
CREATE TABLE
Generate a table
COPY TABLE
Copying a table
RENAME TABLE
Rename table
DROP TABLE
Delete the table
INSERT
Inserting table rows
DELETE
Delete table rows
ALTER TABLE
Add table columns using
ADD
Delete table columns using
DROP
RENAME COLUMN
Rename table columns
Programming SQL commands
This function is not enabled until the code number
555343
is entered.
You can program SQL commands in the
Programming
operating
mode or in
Positioning with mdi
:
Press the
SPEC FCT
key
Press the
PROGRAM FUNCTIONS
soft key
Shift the soft-key row
Press the
SQL
soft key
Select the SQL command via soft key
Read and write accesses performed with the help of
SQL commands always occur in metric units, regardless
of the unit of measure selected for the table or the NC
program.
If, for example, a length is saved from one table to a Q
parameter, then the value is thereafter always in metric
units. If this value is then use in an inch program for the
purpose of positioning (
L X+Q1800
), then an incorrect
position will be the result.