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. 이전 1 2 다음 728x90 반응형