; ; $Header: concat30.inp,v 1.1 1991/01/03 13:22:48 LOSBORNE Exp $ ; /* Copyright 1988, 1991 by the Oracle Corporation */ SQL*FORMS_VERSION = 03.00.13.03.00 DEFINE FORM NAME = CONCAT30 TITLE = EXITTEST DEFAULT_MENU_APPLICATION = ROOT_MENU = GROUP_NAME = MOUSE_NAVIGATION_LIMIT = VALIDATION_UNIT = DEFINE BLOCK NAME = emp DESCRIPTION = emp TABLE = EMP UNIQUE_KEY = OFF UPDATE_KEY = OFF IN_MENU = ON ROWS_DISPLAYED = 1 ROWS_BUFFERED = 1 BASE_LINE = 1 LINES_PER_ROW = 0 ARRAY_SIZE = 0 COLUMN_SECURITY = OFF ORDERING = DEFINE FIELD NAME = EMPNO DATATYPE = NUMBER LENGTH = 6 DISPLAY_LENGTH = 6 QUERY_LENGTH = 6 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = ON DISPLAYED = ON PAGE = 1 LINE = 7 COLUMN = 38 HELP = Enter value for : EMPNO LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = OFF DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = ENAME DATATYPE = CHAR LENGTH = 10 DISPLAY_LENGTH = 10 QUERY_LENGTH = 10 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 10 COLUMN = 19 HELP = Enter value for : ENAME LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = OFF DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF DEFINE TRIGGER /* test */ NAME = key-help TRIGGER_TYPE = V2 SHOW_KEY = OFF DESCRIPTION = DEFINE STEP LABEL = TEXT = <<< #concat >>> SUCCESS_STEP = FAILURE_STEP = FAIL_MESSAGE = ABORT = ON REVERSE = OFF NEW_CURSOR = OFF IGNORE = ON ENDDEFINE STEP ENDDEFINE TRIGGER ENDDEFINE FIELD DEFINE FIELD NAME = JOB DATATYPE = CHAR LENGTH = 9 DISPLAY_LENGTH = 9 QUERY_LENGTH = 9 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 10 COLUMN = 37 HELP = Enter value for : JOB LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = OFF DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD DEFINE FIELD NAME = MGR DATATYPE = NUMBER LENGTH = 6 DISPLAY_LENGTH = 6 QUERY_LENGTH = 6 BASE_TABLE = ON PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 10 COLUMN = 57 HELP = Enter value for : MGR LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = OFF DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = ON FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF DEFINE TRIGGER NAME = POST-FIELD TRIGGER_TYPE = V2 SHOW_KEY = ON DESCRIPTION = DEFINE STEP LABEL = TEXT = <<< #CONCAT ENAME,JOB,MGR,CONCAT >>> SUCCESS_STEP = FAILURE_STEP = FAIL_MESSAGE = CONCAT TRIGGER FAILED ABORT = ON REVERSE = OFF NEW_CURSOR = OFF IGNORE = OFF ENDDEFINE STEP ENDDEFINE TRIGGER ENDDEFINE FIELD DEFINE FIELD NAME = CONCAT DATATYPE = CHAR LENGTH = 31 DISPLAY_LENGTH = 31 QUERY_LENGTH = 31 BASE_TABLE = OFF PRIMARY_KEY = OFF MANDATORY = OFF DISPLAYED = ON PAGE = 1 LINE = 15 COLUMN = 32 HELP = LOW_VALUE = HIGH_VALUE = LOV_TEXT = LOV_TITLE = LOV_X = 0 LOV_Y = 0 INPUT_MASK = OUTPUT_MASK = EDIT_X = 0 EDIT_Y = 0 EDIT_TOP_TITLE = EDIT_BOTTOM_TITLE = EDIT_WORD_WRAP = OFF DEFAULT = ENFORCE_KEY_FROM = ECHO = ON INPUT = ON UPDATE = ON UPDATE_NULL = OFF QUERY = OFF FIXED_LENGTH = OFF AUTOSKIP = OFF AUTOHELP = OFF UPPERCASE = OFF PROMPT = PROMPT_POSITION = BESIDE PROMPT_REPEAT = OFF ENDDEFINE FIELD ENDDEFINE BLOCK DEFINE SCREEN DEFINE PAGE PAGE = 1 POPUP = OFF BORDER = OFF HORIZONTAL_SCROLL_BAR = OFF VERTICAL_SCROLL_BAR = OFF DISSOLVE = OFF TITLE = PAGE_XS = 0 PAGE_YS = 0 PAGE_PX0 = 0 PAGE_PY0 = 0 PAGE_PXS = 0 PAGE_PYS = 0 PAGE_SX0 = 0 PAGE_SY0 = 0 MODE = TEXT LINE = 2 BOILER = <<< CONCATENATION TEST USING A USER EXIT >>> LINE = 7 BOILER = <<< EMPNO >>> LINE = 10 BOILER = <<< ENAME JOB MGR >>> LINE = 15 BOILER = <<< CONCATENATED VALUE >>> MODE = BOX LINE = 2 BOILER = <<< p------------- ---------q | | | | | | | | | | | | | | | | | | | | | | | | | | | b----------------u-----n------------d | | | | | | | | | | b------------------------------------------------------------d >>> ENDDEFINE PAGE ENDDEFINE SCREEN ENDDEFINE FORM