PROCEDURE CHECK_UNCHECK_ALL (V_STAT varchar2) IS
BEGIN
    go_block('BLOCK1');
 -- ubah record paling atas
 first_record;  
 
 if Get_Block_Property( 'BLOCK1) =
    Get_Block_Property( 'BLOCK1) then
        
        :BLOCK1.STATUS := V_STAT;
                
 end if;
 -----------------------------
 -- ubah dari belakang  
 last_record;
 
 while Get_Block_Property( 'BLOCK1', CURRENT_RECORD) <>
       Get_Block_Property( 'BLOCK1', top_RECORD) 
       loop
 
    :BLOCK1.STATUS := V_STAT; 
      
  previous_record;
  
 end loop;
 first_record;
END;

  note
  STATUS = check box
  V_STAT = check / uncheck (valuenya Y/N)
fata hudaya <[EMAIL PROTECTED]> wrote:
          Dear All,

Kalo bikin check box dan bisa di check all dan uncheck all di oracle form 
gimana ya ?
Makasih untuk jawabannya.

Best Regards,

Fata Hudaya,
+628567143271
[EMAIL PROTECTED]

__________________________________________________________ 
Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for
your free account today 
http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html 

[Non-text portions of this message have been removed]



         

       
---------------------------------
Park yourself in front of a world of choices in alternative vehicles.
Visit the Yahoo! Auto Green Center.

[Non-text portions of this message have been removed]

Kirim email ke