meta data for this page
  •  

ENUM data type

The ENUM data type is useful for input parameters when it is necessary to allow users to select a value from a given set of values.

Example

  execute ibeblock (MonthName enum ('January', 'February', 'March',
                                    'April', 'May', 'June', 'July',
                                    'August', 'September', 'October',
                                    'November', 'December') default = 0)
  as
  begin
    ...
  end;

For each input parameter of type ENUM IBExpert will create a combobox with the corresponding set of items. See Copy database object blocks to learn how this works.