Re: [indo-oracle] [ask] Forms : menampilkan multiple record

Tue, 16 May 2006 01:00:56 -0700

BEGIN
   go_block('block1');
   first_record;
   LOOP

       go_block('block2');

       IF(:block1.chek_box=1) THEN  /*Check if the user has checked the
checkbox */
          :block2.CUST_ID := :block1.CUST_ID;
         :block2.AMOUNT := :block1.AMOUNT;
         dst.. dst ..

          next_record;
       END IF;

       go_block('block1');

       IF(:System.Last_Record = 'TRUE') THEN
          exit;
       ELSE
          next_record;
       END IF;

    END LOOP;
END;


Salam,

Indra Armansyah


----- Original Message -----
From: "abang sunda" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, May 16, 2006 10:45 AM
Subject: [indo-oracle] [ask] Forms : menampilkan multiple record


> dear all,
> mo minta tulung , ada masalah dikit di forms.
> sy ada satu block dr base table(block1) dg displayed 5
> record, dg chek box di tiap record
> di bawhnya ada block lagi (block2) untuk menampung
> record
> yg dipilih dr block1 diatas.
>
> tp ketika dicoba, kok yg tampil hanya record terakhir
> saja dr block1 ?
>
> ini sqlnya di when button pressed:
>
> BEGIN
> go_block('block1');
> first_record;
>
>  LOOP
>
>    IF(:System.Last_Record = 'TRUE') THEN
>      exit;
>    END IF;
>
>    IF(:block1.chek_box=1) THEN  /*Check if the user
> has checked the checkbox */
>    :block2.CUST_ID := :block1.CUST_ID;
>    :block2.AMOUNT := :block1.AMOUNT;
>    dst.. dst ..
>    END IF;
>
>      next_record;
>
>  END LOOP;
>
> END;
>
> bingung nih.
> atau ada cara lain copy multiple records
> ke block lain ?
>
> makasih
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.lizt.org (NEW)
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
> --
> Internal Virus Database is out-of-date.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 268.5.3/331 - Release Date: 5/3/2006
>
>



--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com


YAHOO! GROUPS LINKS



Kirim email ke