Sekedar menambahkan, Sebagai alternatif lain, coba convert isi procedure yg mengandung cursor tsb menjadi stored procedure (sebut saja SP1). Kemudian set data source dari block yg bersangkutan dengan menggunakan stored procedure (SP1) tsb.
Bowo --- In [email protected], Ujang Jaenudin <[EMAIL PROTECTED]> wrote: > bisa pake : > 1. di property block > query data source type = from clause query > query data source name = select bla...bla...bla..... > tapi harus set 1 item sebagai primary key > > 2. dengan menggunakan cara unbound. > data diambil dari cursor , terus tampilkan di masing2 item. > > J > > > risna septi wrote: > > >thanks, tapi itu querynya mencari sum table seperti yg saya send kmaren > >cari sum points and point namenya dr master pointname. > > > >select sum (db) points,pointname > > > > > >>> > >>> > >>> > >>> > >>>from dtl_trackpoint a, mst_points b > >> > >> > >> > >> > >>>where a.point_id=b.row_id and > >>>mcc_code=:permanen_code > >>>group by pointname; > >>> > >>> > > > >so, hrs ada selectnya, tdk bisa pake where aja.gimana yahhh?? > > > > > > > >Ujang Jaenudin <[EMAIL PROTECTED]> wrote: > >hi risna , saya pakai 2 cara : > > > >1. tinggal set property block di where clause > >Doc_Status = :Doc_Title.Wo_Status > > > >2. set dynamically throgh pl/sql block code, > >Set_Block_Property('PRODUCT',DEFAULT_WHERE,'NVL(DOC_STATUS,''X'') = > >'||'''' ||:DOC_TITLE.WO_STATUS ||''''); > >Go_Block('Product'); > >Execute_Query; > > > > > >J > > > > > >risna septi wrote: > > > > > > > >>thanks, its work.. > >>klu pakai query di block ada juga khan?? tapi blum tahu makainya.... kayaknya kita pakai select statement diblock... ada yg tahu?? > >> > >> > >>Ujang Jaenudin <[EMAIL PROTECTED]> wrote: > >>hi risna, hope this help. > >> > >>declare > >>CURSOR get_locn IS > >> SELECT locn_Code,Locn_Name FROM location_storage > >> WHERE whs_code = :WAREHOUSE.WHS_CODE > >> AND locn_type IN ('N','W','C') > >> AND mrp = DECODE(0,10,'Y',mrp); > >>BEGIN > >> Go_Block('STOCK_ALL_LOC'); > >> First_Record; > >> Loop > >> :STOCK_ALL_LOC.LOCN_CODE := null; > >> :STOCK_ALL_LOC.OCN_NAME := null; > >> :STOCK_ALL_LOC.STK_QTY := null; > >> If :system.Last_Record = 'TRUE' then > >> exit; > >> End If; > >> Next_Record; > >> End Loop; > >> > >> first_record; > >> FOR I IN get_locn LOOP > >> :STOCK_ALL_LOC.LOCN_CODE := I.locn_Code; > >> :STOCK_ALL_LOC.OCN_NAME := I.Locn_Name; > >> :STOCK_ALL_LOC.STK_QTY := > >>NVL(get_cnf(I.locn_Code,:curr_stock.item_code),0); > >> next_record; > >> END LOOP; > >>END; > >> > >> > >>J > >> > >>risna septi wrote: > >> > >> > >> > >> > >> > >>>hallo all, > >>>mo tanya... create cursor n hasilnya bisa dimasukkan ke multiple record form? > >>>contoh ada 2 field > >>>saya uda coba, tapi yg keluar hny record pertama aja... > >>> > >>>ada bantuan dr teman2?? > >>> > >>>PROCEDURE pointcalc IS > >>>cursor cp is > >>>select sum (db) points,pointname > >>> > >>> > >>> > >>> > >>>from dtl_trackpoint a, mst_points b > >> > >> > >> > >> > >>>where a.point_id=b.row_id and > >>>mcc_code=:permanen_code > >>>group by pointname; > >>>pn varchar2 (60); > >>>p number; > >>>BEGIN > >>>go_block ('points'); > >>>first_record; > >>>loop > >>>open cp; > >>> fetch cp into :point.point,:point.pointname; > >>> next_record; > >>> IF :System.Last_Record = 'TRUE' THEN > >>> EXIT; > >>> END IF; > >>> > >>> close cp; > >>>end loop; > >>> > >>> > >>>END; > >>> > >>> > >>> > >>> > > > Send instant messages to your online friends http://asia.messenger.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hjcih15/M=362335.6886445.7839731.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124352186/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> -- -----------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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
