From variable

Symbol

Some transfer functions allow you to save a retrieved value as a variable for later use within a transfer script.

 

At the start of the transfer script, you can use a Assembly to draw a number for a process from the number groups. The process number is recorded in a variable and is available for further functions within the transfer script.

The From variable functionality allows a previously filled variable to be read out and written to the target database.

'Input help' area

Source alias

This is the database alias for the data source specified in the main node (transfer).

 

Changes made here will be reflected in the Transfer main node.

Target alias

The database alias in the main node (Transfer) for the target is shown here.

 

Changes made here will be reflected in the Transfer main node.

'From variable' area

Variable

Specifies the name of a previously completed variable that is to be read out and transferred into the previously marked target field.

From character / to character

These two fields are used to specify how many characters of the variable are to be used.

  • 0 corresponds to the first character

  • 1 to the second character

  • 2 to the third character

  • -1 to the last character

  • -2 to the next to last character

  • etc.

 

To use all the characters of a variable, enter the value 0 in the From character field and -1 in the To character field.

'Target' area

Overwrite font

This option can only be set when the target field type is Long text (RichText).

The button is used to define the font to be used in the target field.

 

You can use this option to change the font if the source table is also the target table.

Also see Transfer - Change item fonts

Variable

Activate the Variable option if the value from the function is to be written in a variable.

When Long text (RichText) fields are transferred, the button can also be used to change the font.

Also see Transfer - Change item fonts

Variable

Enter a unique name for the variable. You can also use variables that are already used in the transfer. You can specify if the value of the variable is replaced or the new value is appended using the Mode.

Mode

The Mode determines whether the value in the variable is to be overwritten or the new value appended after the existing value.

Set

The value of the variable is overwritten.

Concat

The newly determined value is appended after the existing value of the variable (concatenated).

Field

Activate this option if the value from the function is to be transferred to a field.

Table

Select a table. The tables from the target alias are listed here for selection.

Variable

The corresponding fields from the selected table are shown here for selection.

The values of the function are transferred into this field.

Field type / Field length

These values are taken from the database information as far as possible.

They can be manually edited if required for undefined types and lengths.