Changing the row of a result set with SQL UPDATE

Application

SQL UPDATE changes a row in the result set. The new values of the individual cells are copied by the control from the bound variables. The transaction is defined through the HANDLE to be specified, and the row is defined by the INDEX. The control completely overwrites the already existing rows in the result set.

Requirements

  • Code number 555343
  • Table exists
  • Appropriate table name
  • 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 data are input or read.

Description of function

Black arrows and the associated syntax show internal SQL UPDATE processes. Gray arrows and the associated syntax are not directly associated with the SQL UPDATE command.

SQL UPDATE takes all of the columns into consideration that contain the SELECT instruction (SQL command SQL EXECUTE).

The control shows in the defined variable whether the read operation was successful (0) or incorrect (1).

Input

NC programs contained in this User's Manual are suggestions for solutions. The NC programs or individual NC blocks must be adapted before being used on a machine.

Change the following contents as needed:

  • Tools
  • Cutting parameters
  • Feed rates
  • Clearance height or safe position
  • Machine-specific positions (e.g., with M91)
  • Paths of program calls

Some NC programs depend on the machine kinematics. Adapt these NC programs to your machine kinematics before the first test run.

In addition, test the NC programs using the simulation before the actual program run.

 
Tip

With a program test you determine whether the NC program can be used with the available software options, the active machine kinematics and the current machine configuration.

11 SQL UPDATE Q1 HANDLE Q5 index5 RESET UNBOUND

; Complete all rows of transaction Q5 and update table

The NC function includes the following syntax elements:

Syntax element

Meaning

SQL UPDATE

Syntax initiator for the UPDATE SQL command

Parameter

Variable in which the control stores the result

HANDLE

Variable with identification of the transaction

INDEX

Row number within the Result-set as a number or variable

Optional syntax element

If not specified, the control accesses line 0.

RESET UNBOUND

For the machine manufacturer only

Optional syntax element

Note

When writing to tables, the control checks the lengths of the string parameters. If the entries exceed the length of the columns to be described, then the control outputs an error message.

Example

NC programs contained in this User's Manual are suggestions for solutions. The NC programs or individual NC blocks must be adapted before being used on a machine.

Change the following contents as needed:

  • Tools
  • Cutting parameters
  • Feed rates
  • Clearance height or safe position
  • Machine-specific positions (e.g., with M91)
  • Paths of program calls

Some NC programs depend on the machine kinematics. Adapt these NC programs to your machine kinematics before the first test run.

In addition, test the NC programs using the simulation before the actual program run.

 
Tip

With a program test you determine whether the NC program can be used with the available software options, the active machine kinematics and the current machine configuration.

Transfer line number in the Q parameter

11 SQL BIND Q881 "TAB_EXAMPLE.Position_NR"

12 SQL BIND Q882 "TAB_EXAMPLE.Measure_X"

13 SQL BIND Q883 "TAB_EXAMPLE.Measure_Y"

14 SQL BIND Q884 "TAB_EXAMPLE.Measure_Z"

* - ...

21 SQL Q5 "SELECT Position_NR,Measure_X,Measure_Y,Measure_Z FROM TAB_EXAMPLE"

* - ...

31 SQL FETCH Q1 HANDLE Q5 INDEX+Q2

NC programs contained in this User's Manual are suggestions for solutions. The NC programs or individual NC blocks must be adapted before being used on a machine.

Change the following contents as needed:

  • Tools
  • Cutting parameters
  • Feed rates
  • Clearance height or safe position
  • Machine-specific positions (e.g., with M91)
  • Paths of program calls

Some NC programs depend on the machine kinematics. Adapt these NC programs to your machine kinematics before the first test run.

In addition, test the NC programs using the simulation before the actual program run.

 
Tip

With a program test you determine whether the NC program can be used with the available software options, the active machine kinematics and the current machine configuration.

Program the row number directly

31 SQL UPDATE Q1 HANDLE Q5 INDEX5