The internalhandlers table

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.

adding records from an external file to a table

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
 

adding a record to a table

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
 

setting a field in a record

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 !

remove a record in a table

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  

set the selected key

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