FORMCONT table
It is possible to initialize options of select boxes from the database. This is often used when the values change dynamically. For example a job that writes all available options can be scheduled for every night. When a new process starts then the options are always fresh. Once the process is started and options are read then the they remain in the cache. When the process is later interrupted and opened again it still contains its original options.
The FORMCONT database table is defined this way:
FORMNAME name of the form in uppercase without .xml extension.
STMT statement type (JOB, EXEC,...).
NAME id specified inXML section.
LBL label of the item visible on the web page.
VAL value of the item used when its label is selected on the web page. NULL is allowed and has a meaning of an empty string.
USR NULL or user id. If the value is NULL then the option is available for all users. If you want to offer it only for a particular Procman user then use his user id.
When options for a form field exist in the database then they always completely overwrite options coded in XML form definition.
It is highly recommended to have options only in one place - in XML or in FORMCONT to prevent problems.
It is also possible to add additional options by calling ADDFORMOPTION rule function. This function appends options to the ones that already exist.
Last updated