الانتقال إلى المحتوى
View in the app

A better way to browse. Learn more.

مجموعة مستخدمي أوراكل العربية

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

blink multiple fields, timer

Featured Replies

بتاريخ:

hi

Calling a Timer from 2 triggers, WHEN-NEW-FORM-INSTANCE & WHEN-LIST-CHANGE to know the value for :prop_select

Declare
    timer_id  timer ;
Begin
   timer_id:=FIND_TIMER('FBLINK');
   IF NOT ID_NULL(    timer_id) THEN
      DELETE_TIMER(    timer_id);
   END IF;
    timer_id := Create_Timer( 'FBLINK', 200, REPEAT ) ;
  --tm:=CREATE_TIMER('VBLINK', 1000, REPEAT);
end;

WHEN-TIMER-EXPIRED

declare
    
    v_timer_name VARCHAR2(100);    

cursor c_tenant_rnw is select s.spec_part_no
from   tenant_contract r , dc_lease_txn d, inv_product_spec s
where  r.tenant_code = d.dc_lease_no
and    d.DC_LEASE_ITEM_CODE  = s.spec_id
and    s.spec_prod_code      = :prop_select;

returns the following data at the back end.
spec_part_no
F36
F73
O11

m_blk_fld varchar2(15);
begin
  v_timer_name :=GET_APPLICATION_PROPERTY (timer_name);
  if v_timer_name = 'FBLINK' THEN    
-- CODE1 - FILEDS DOES NOT BLINK
     Go_block('block3');
     for ix in c_tenant_rnw loop
         m_blk_fld := '''block3.'||ix.spec_part_no||'''';
            
       if Get_Item_Property(m_blk_fld, FOREGROUND_COLOR )
        != Get_Item_Property(m_blk_fld, BACKGROUND_COLOR ) Then
        Set_Item_Property(m_blk_fld, FOREGROUND_COLOR, Get_Item_Property(m_blk_fld, BACKGROUND_COLOR ) ) ;
     Else 
        Set_Item_Property(m_blk_fld, FOREGROUND_COLOR, 'r0g0b0' ) ;
     End if ;

/* CODE2 when i run the below piece of code individually for the 3 fields, F36, F73 & O11, they blinks perfectly
        -- FIELD F36
    If Get_Item_Property('block3.F36', FOREGROUND_COLOR )
           != Get_Item_Property('block3.F36', BACKGROUND_COLOR ) Then
       Set_Item_Property('block3.F36', FOREGROUND_COLOR, Get_Item_Property('block3.F36', BACKGROUND_COLOR ) ) ;
    Else
       Set_Item_Property('block3.F36', FOREGROUND_COLOR, 'r0g0b0' ) ;
    End if ;
        -- FIELD F73
    If Get_Item_Property('block3.F73', FOREGROUND_COLOR )
       != Get_Item_Property('block3.F73', BACKGROUND_COLOR ) Then
       Set_Item_Property('block3.F73', FOREGROUND_COLOR, Get_Item_Property('block3.F73', BACKGROUND_COLOR ) ) ;
    Else
      Set_Item_Property('block3.F73', FOREGROUND_COLOR, 'r0g0b0' ) ;
    End if ;
        -- FIELD F81
    If Get_Item_Property('block3.O11', FOREGROUND_COLOR )
       != Get_Item_Property('block3.O11', BACKGROUND_COLOR ) Then
       Set_Item_Property('block3.O11', FOREGROUND_COLOR, Get_Item_Property('block3.O11', BACKGROUND_COLOR ) ) ;
    Else
       Set_Item_Property('block3.O11', FOREGROUND_COLOR, 'r0g0b0' ) ;
    End if ;
*/
    next_record;
     end loop;
  end i
f

on my form control block (block3), there are about 100 fields having their names as F1,F2,F3… to F100.
i want to blink several fields of the block (block3) simultaneously, depending on the values getting return from the query.
the names of the fields of block3 are exactly the same as the rows retreived from query.

i want the WTE code to run as per CODE1 logic, and NOT individually as code2.

please if someone could help me correct my above code, i would appreciate that alot.
Thanks

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية

Account

Navigation

البحث

إعداد إشعارات المتصفح الفورية

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.