Wednesday, September 20, 2017

Forms Alert

Example 1 :

 SHOW_ALT('PMF_M35_007',V_ALET);
        IF   UPPER(V_ALET)  = 'NO' THEN         
            RETURN;
            GO_ITEM('CTRL_MEDICATION.BATCH_NO');
        END IF;

Related Posts:

  • Triks for oracle To assign search text in search box : <>:CTRL_BLK.COMPLAIN_SRC:='<<Search Complain>>'; To assing item record sl. no: use post query trigger block level: <>:EMV_COMPLAIN.sl :=:system.trigger_record; … Read More
  • SQL: ## Used for show table name whose column name is user input : SELECT TABLE_NAME FROM USER_TAB_COLUMNS WHERE UPPER(COLUMN_NAME)='COLUMN_NAME'      Sub query : select  appoint_date,doc_name,doctor_no,doc… Read More
  • Trigger in oracle forms All lINK : 1. http://www.123techguru.com/types-of-controls/ Built_in sub programs used in Form Triggers . 1 commit_form used to save changes ( Valid for DML ) 2 clear_form clears all the blocks in form and place t… Read More
  • Sql Query: Count duplicate value 1. SELECT REG_NO, COUNT(REG_NO)  FROM OP_APPOINTMENT WHERE APPOINT_DATE BETWEEN NVL(:P_DT1,APPOINT_DATE) AND NVL(:P_DT2,APPOINT_DATE) GROUP BY REG_NO HAVING ( COUNT(REG_NO) > 1 ) 2. select PO… Read More
  • To show  and tik mark and croos mark in oracle report; 1. first try to keep value for tik mark P and for cross mark O  for help try as following query : SELECT C.COMP_NO, C.COMP_DT, C.COMP_PRIORITY,   &… Read More

0 comments:

Post a Comment