beautypg.com

Sql bind, Accessing tables with sql commands 9.9 – HEIDENHAIN TNC 620 (73498x-02) User Manual

Page 303

background image

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