Pake fasilitas database aja pak. Udah Coba sqlpreview pak? Versi brp pb? -----Original message----- From: Hermawan Dephe Sent: 26/05/2011, 13:19 To: [email protected] Subject: Re: [indopb] GetSQLSelect with paramater value
Hmmm.., sepertinya emang tidak bisa,, :D ini buat trace sql di datawindow pak zul.. ane punya 1 window dengan 1 dw control yg manggil banyak datawindow(pake choose case) 1 dw ini jg banyak argumennya.. kan enak kayaknya kalo tracenya, ane cukup bikin aja textbox + tombol.Saat klik tombolnya maka textbox akan terisi sql syntax di datawindowyg lagi running..(pake getsqlselect tadi) hehe ini cuman karena ribett aja kalo kudu trace sqlnya, trus ane kuducopas sqlnya trus kudu replace atu2 nama argumennya dengan nilaisebenarnya. zulmach wrote: skenario nya gimana pak hermawan? perlunya utk apa ya hehe maap nanya nya rada aneh.............. Voice. +62 816 74 77 67 Text. +62 856 10000 74 email. [email protected] (mailto:[email protected]) YMID. zulmach Website. www.zulmach.wordpress.com (http://www.zulmach.wordpress.com) www.pemulapb.wordpress.com (http://www.pemulapb.wordpress.com) On Thu, May 26, 2011 at 12:43 PM, Gunawan,PE (Peter) <[email protected] (mailto:[email protected])>wrote: Kalo bolehbantu jelasin: Di PB kanada GetSQLSelect, nah kalo query kita ternyata pake retrieval argumen,query yang didapat dari GetSQLSelect itu berupa query mentah tanpavalue dari retrieval argumennya. Misal datawindowdengan argumen tgl : 24-mei-2011 Nah yang bro Her mau,supaya value 24-mei-2011 itu juga berhasil terambil bersama denganquery select nya. Sementara kalo hanyadengan GetSQLSelect itu tanpa valuenya, tapi hanya nama variableretrievalnya. -peter- From: [email protected] (mailto:[email protected])[mailto:[email protected] (mailto:[email protected])] On Behalf Of WarasMad Sent: Thursday, May 26, 2011 12:33 PM To: [email protected] (mailto:[email protected]) Subject: Bls: [indopb] GetSQLSelect with paramater value Bro.. Her.. ane kurang mengerti pertanyaan ente... maksud nya ente mau dapetin , apa sihh? ------------------------------------- Dari: Hermawan Dephe <[email protected] (mailto:[email protected])> Kepada: [email protected] (mailto:[email protected]) Terkirim: Kam, 26 Mei, 2011 08:39:47 Judul: [indopb] GetSQLSelect with paramater value Assalam.. mo nanya nih rekan PBers.. pastinya smua dah pada pernah pake donk perintah GetSQLSelect & SetSQLSelect tp yg ane mo tanyain nih gan... soal GetSQLSelect ( ), kan dipakenya bwt ngambil syntax SQL yg ada dalam datawindow.. yg ane pengen tuh gan.. bisa gak ya perintah ini ngambil berikut dengan nilai parameternya.. Misal sql di dalem datawindownya "SELECT * FROM MEMBER WHERE NO_ID = :ls_noid" trus gw pengen dapetin juga tuh nilai parameternya misal ls_noid = '001' jadinya sql yg gw dapat adalah "SELECT * FROM MEMBER WHERE NO_ID ='001'" di PB pake cara apa ya gan?? apa emang kagak bisa ya? :D Terima kasih... ------------------------------------- This email(including any attachments to it) is confidential, legally privileged,subject to copyright and is sent for the personal attention of theintended recipient only. If you have received this email in error,please advise us immediately and delete it. You are notified thatdisclosing, copying, distributing or taking any action in reliance onthe contents of this information is strictly prohibited. Although wehave taken reasonable precautions to ensure no viruses are present inthis email, we cannot accept responsibility for any loss or damagearising from the viruses in this email or attachments. We exclude anyliability for the content of this email, or for the consequences of anyactions taken on the basis of the information provided in this email orits attachments, unless that information is subsequently confirmed inwriting. If this email contains an offer, that should be considered asan invitation to treat. ------------------------------------- ------------------------------------ ----------------------------------------------- IndoPB - Indonesia PB User Group http://groups.yahoo.com/group/indopbYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indopb/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
