This is a 'database table' parameter. Please refer to passing database tables for a detailed explanation of database tables layout. In all the following examples we assume that the recordseparator is ^ and the fieldseparator is | .
Internal handlers can perform different tasks. The task defines the value and the type of the different fields.
task = 0
| Record definition | ||||
|---|---|---|---|---|
| Field | Name | Type | Default | Range |
| 0 | key | string | no default, obligatory field | |
| 1 | task | decimal integer | no default, obligatory field | should be 0 for adding records from an external file |
| 2 | table | string | no default, obligatory field | the name of the table where the new rows should be added to |
| 3 | URL | string | no default, obligatory field | the URL of the external file where the new fields can be found |
task = 1
| Record definition | ||||
|---|---|---|---|---|
| Field | Name | Type | Default | Range |
| 0 | key | string | no default, obligatory field | |
| 1 | task | decimal integer | no default, obligatory field | should be 1 for adding a record |
| 2 | table | string | no default, obligatory field | the name of the table where the new record should be added to |
| 3 and further |
record | record | see specific table | |
task = 2
| Record definition | ||||
|---|---|---|---|---|
| Field | Name | Type | Default | Range |
| 0 | key | string | no default, obligatory field | |
| 1 | task | decimal integer | no default, obligatory field | should be 2 for setting a field in a record |
| 2 | table | string | no default, obligatory field | the name of the table where the field should be set |
| 3 | key (to set) |
string | no default, obligatory field | |
| 4 | value (to set) |
depends on destination field | no default, obligatory field | |
| 5 | field index | integer | default = 1 | index 0 is the key ! |
task = 3
| Record definition | ||||
|---|---|---|---|---|
| Field | Name | Type | Default | Range |
| 0 | key | string | no default, obligatory field | |
| 1 | task | decimal integer | no default, obligatory field | should be 3 for removing records |
| 2 | table | string | no default, obligatory field | the name of the table where record should be removed from |
| 3 | key (to delete) |
string | no default, obligatory field | |
task = 4
| Record definition | ||||
|---|---|---|---|---|
| Field | Name | Type | Default | Range |
| 0 | key | string | no default, obligatory field | |
| 1 | task | decimal integer | no default, obligatory field | should be 0 for loading |
| 2 | table | string | should be blank | |
| 3 | key (to be selected) |
string | no default, obligatory field | |