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 |