Programming Q Parameters | Accessing tables with SQL commands
10
HEIDENHAIN | TNC 620 | Conversational Programming User's Manual | 10/2017
425
10.9
Accessing tables with SQL commands
Introduction
If you would like to access numerical or alphanumerical
content in a table or manipulate the table (e.g., rename
columns or rows), then use the SQL commands
available to you.
The syntax of the SQL commands available on the
control is heavily influenced by the SQL programming
language—but does not conform to it completely. In
addition, the control does not support the entire scope
of the SQL language.
The names of tables and table columns must start with
a letter and must not contain an arithmetic operator
(e.g.,
+
). Due to SQL commands, these characters can
cause problems when inputting data or reading it out.
The following terms will be used (along with others) in
the following:
“SQL command” refers to the available soft keys
“SQL instructions” describe miscellaneous functions
that are entered manually as part of the syntax
In the syntax,
HANDLE
stands for a transaction
(followed by the identifying parameter)
The
Result set
contains the query result (referred to
in the following as “intermediate memory”)
Read and write access to individual numerical values of
a table can likewise be carried out using the function
FN
26: TABOPEN
,
FN 27: TABWRITE
and
FN 28: TABREAD
.
In the NC software, access to tables is gained via an SQL server.
This server is controlled with the available SQL commands. The
SQL commands can be defined directly in an NC program.
The saver is based on a transaction model. A
transaction
is made
up of multiples steps that are executed together, thereby ensuring
an orderly and defined processing of the table entries.
Summary of Contents for TNC 620 E
Page 4: ......
Page 5: ...Fundamentals...
Page 34: ...Contents 34 HEIDENHAIN TNC 620 Conversational Programming User s Manual 10 2017...
Page 63: ...1 First Steps with the TNC 620...
Page 86: ......
Page 87: ...2 Introduction...
Page 123: ...3 Operating the Touchscreen...
Page 139: ...4 Fundamentals File Management...
Page 199: ...5 Programming Aids...
Page 228: ......
Page 229: ...6 Tools...
Page 271: ...7 Programming Contours...
Page 323: ...8 Data Transfer from CAD Files...
Page 344: ......
Page 345: ...9 Subprograms and Program Section Repeats...
Page 364: ......
Page 365: ...10 Programming Q Parameters...
Page 467: ...11 Miscellaneous Functions...
Page 489: ...12 Special Functions...
Page 532: ......
Page 533: ...13 Multiple Axis Machining...
Page 596: ......
Page 597: ...14 Pallet Management...
Page 610: ......
Page 611: ...15 Batch Process Manager...
Page 619: ...16 Manual Operation and Setup...
Page 693: ...17 Positioning with Manual Data Input...
Page 698: ......
Page 699: ...18 Test Run and Program Run...
Page 737: ...19 MOD Functions...
Page 774: ......
Page 775: ...20 Tables and Overviews...