본문 바로가기
728x90
반응형

forms7

set_item_instance_property TRIGGER : WHEN-VALIDATE-ITEM set_item_instance_property('MAIN.COMMENTS', current_record, REQUIRED, property_true); set_item_instance_property('MAIN.COMMENTS', current_record, VISUAL_ATTRIBUTE, 'DATA_REQUIRED'); 2024. 1. 19.
KEY-LISTVAL 과거일자 선택할 수 없게 CALENDAR.SETUP('DISABLE DATES', NULL,TRUNC(sysdate)-1, NULL); CALENDAR.SHOW; TRIGGER : KEY-LISTVAL 오늘 이전 날짜는 선택할 수 없게 된다. 2024. 1. 9.
Oracle Forms – Remove List Element from List Item LIST ITEM 사용시 마지막 라인 공백라인 없앨 때 아래 단축기로 삭제 CTRL + SHIFT + , 2023. 6. 30.
set_item_property BACKGROUND_COLOR 시 컬러색표시 BACKGROUND_COLOR The color of the object's background region. The property value is a reference to an RGB value such as r191g223b191. 색속성 입력시 RGB값으로 해야 적용됨, white/WHITE 안먹음 set_item_property('블록명.컬럼명' , BACKGROUND_COLOR, 'r255g255b255'); 2023. 5. 23.
Steps to Remove the Unneeded List Elements in the Elements List Window Using Forms Builder (Doc ID 2824543.1) APPLIES TO: Oracle E-Business Suite Technology Stack - Version 12.2 and later Information in this document applies to any platform. GOAL In Oracle Developer Forms [32Bit] Version10.1.2.0.2 (Forms Builder), we can add list elements from the Property Palette of the List Items for Poplist by hitting the Down-arrow key in the Elements List window. More rows can be added and cannot be removed. What a.. 2023. 3. 28.
APP_FIELD: Item Relationship Utilities This section describes utilities you can use to maintain relationships between your form items. 연결된 필드들에 대해서 첫번째 필드 값 변경 시 나머지 필드들에 대하여 CLEAR 할 때 사용 APP_FIELD.CLEAR_FIELDS procedure APP_FIELD.CLEAR_FIELDS( field1 varchar2, field2 varchar2 default NULL, field3 varchar2 default NULL, field4 varchar2 default NULL, field5 varchar2 default NULL, field6 varchar2 default NULL, field7 varchar2 default N.. 2023. 1. 12.
728x90
반응형