HEIDENHAIN MANUALPLUS 620 - Page 1626

1626 HEIDENHAIN Technical Manual MANUALplus 620
SQL BIND The NC block SQL BIND binds a Q parameter to a column of a table. If you
redefine the NC block without specifying a column, the binding will be
canceled.
Otherwise, the binding remains in effect until the current subprogram or cycle
is completed.
Definition
 sql-bind:= SQL BIND q-parameter [ sql-column ]
Example:
SQL BIND Q63 "TCHPROBE.OFFS0"
SQL SYSBIND The NC block SQL SYSBIND binds a system parameter to a column of a table.
If you redefine the NC block without specifying a column, the binding will be
canceled. As with SQL BIND, if not otherwise specified, the binding remains
in effect until the subprogram or cycle is completed.
Definition
 sql-bind := SQL SYSBIND system-parameter [ sql-column ]
Example:
SQL SYSBIND Q63 "ID50 NR1 IDX1"
SQL FETCH The NC block SQL FETCH reads a row from the result set of an SQL query and
assigns the data to the bound parameters. If the values in the table are
expressed in inches, lengths and feed rates are converted into millimeters
during the reading process. The values in the bound parameters are always
assumed to be metric. As with FN18, this also applies if the current program
is entered in inches. If no index has been specified, the first row of the result
set is transferred. The specified Q parameter is assigned a return code. If the
command has been completed successfully, the Q parameter is assigned a
zero. If not, it is assigned a one.
Definition
 sql-fetch:= SQL FETCH q-parameter sql-handle [ sql-index ]
Example:
SQL FETCH Q80 HANDLE Q5 INDEX0
SQL UPDATE The NC block SQL UPDATE assigns the data from the bound parameters to
the corresponding rows or columns of the table. If the values in the table are
expressed in inches, lengths and feed rates are converted into millimeters
before the assignment process. The values in the bound parameters are
always assumed to be metric. As with FN17, this also applies if the current
program is entered in inches.
The specified Q parameter is assigned a return code. If the command has
been completed successfully, the Q parameter is assigned a zero. If not, it is
assigned a one.
Definition
 sql-update := SQL UPDATE q-parameter sql-handle [ sql-index ]
Example:
SQL UPDATE Q80 HANDLE Q5 INDEX0