Sql bind, Accessing tables with sql commands 9.9 – HEIDENHAIN TNC 620 (73498x-02) User Manual
Page 303
Accessing tables with SQL commands
9.9
9
TNC 620 | User's Manual
HEIDENHAIN Conversational Programming | 5/2013
303
SQL BIND
SQL BIND binds a Q parameter to a table column. The SQL
commands "Fetch," "Update" and "Insert" evaluate this binding
(assignment) during data transfer between the result set and the NC
program.
An
SQL BIND command without a table or column name cancels the
binding. Binding remains effective at most until the end of the NC
program or subprogram.
You can program any number of bindings. Read and
write processes only take into account the columns
that were entered in the "Select" command.
SQL BIND... must be programmed
before
"Fetch,"
"Update" or "Insert" commands are programmed.
You can program a "Select" command without a
preceding "Bind" command.
If in the "Select" command you include columns for
which no binding is programmed, an error occurs
during read/write processes (program interrupt).
Parameter no. for result: Q parameter that is
bound (assigned) to the table column.
Database: Column name: Enter the table name and
column name separated by a
. (period)
Table name
: Synonym or path and file name of this
table. The synonym is entered directly, whereas the
path and file name are entered in single quotation
marks
Column designation
: Designation of the table
column as given in the configuration data
Bind a Q parameter to a table column
11SQL BIND Q881
"TAB_EXAMPLE.MEAS_NO"
12SQL BIND Q882
"TAB_EXAMPLE.MEAS_X"
13SQL BIND Q883
"TAB_EXAMPLE.MEAS_Y"
14SQL BIND Q884
"TAB_EXAMPLE.MEAS_Z"
Cancel binding
91 SQL BIND Q881
92 SQL BIND Q882
93 SQL BIND Q883
94 SQL BIND Q884