Ada kok pak. Coba f1 nya -----Original message----- From: Hermawan Dephe Sent: 26/05/2011, 13:32 To: [email protected] Subject: Re: [indopb] GetSQLSelect with paramater value
oh.. ada ya? ane pake PB 6.5 :D Zulkifli Machmur wrote:  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] (mailto:indopb%40yahoogroups.com) 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 banyakdatawindow(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 didatawindowyg lagi running..(pake getsqlselect tadi) hehe ini cuman karena ribett aja kalo kudu trace sqlnya, trus anekuducopas sqlnya trus kudu replace atu2 nama argumennya dengannilaisebenarnya. 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:zulmach%40gmail.com)(mailto:[email protected] (mailto:zulmach%40gmail.com)) YMID.   zulmach Website. www.zulmach.wordpress.com (http://www.zulmach.wordpress.com) (http://www.zulmach.wordpress.com)         www.pemulapb.wordpress.com (http://www.pemulapb.wordpress.com) (http://www.pemulapb.wordpress.com) On Thu, May 26, 2011 at 12:43 PM, Gunawan,PE (Peter) <[email protected] (mailto:Peter.Gunawan%40rabobank.com)(mailto:[email protected] (mailto:Peter.Gunawan%40rabobank.com))>wrote:  Kalo bolehbantu jelasin: Di PB kanada GetSQLSelect, nah kalo query kita ternyata pake retrievalargumen,query yang didapat dari  GetSQLSelect itu berupa query mentahtanpavalue dari retrieval argumennya. Misal datawindowdengan argumen tgl : 24-mei-2011 Nah yang bro Her mau,supaya value 24-mei-2011 itu juga berhasilterambil bersama denganquery select nya. Sementara kalo hanyadengan GetSQLSelect itu tanpa valuenya, tapi hanyanama variableretrievalnya.   -peter-  From: [email protected] (mailto:indopb%40yahoogroups.com)(mailto:[email protected] (mailto:indopb%40yahoogroups.com))[mailto:[email protected] (mailto:indopb%40yahoogroups.com)(mailto:[email protected] (mailto:indopb%40yahoogroups.com))]On Behalf Of WarasMad Sent: Thursday, May 26, 2011 12:33 PM To: [email protected] (mailto:indopb%40yahoogroups.com)(mailto:[email protected] (mailto:indopb%40yahoogroups.com)) 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:wawn1782%40gmail.com) (mailto:[email protected] (mailto:wawn1782%40gmail.com))> Kepada: [email protected] (mailto:indopb%40yahoogroups.com)(mailto:[email protected] (mailto:indopb%40yahoogroups.com)) 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, legallyprivileged,subject to copyright and is sent for the personal attentionof theintended recipient only. If you have received this email inerror,please advise us immediately and delete it. You are notifiedthatdisclosing, copying, distributing or taking any action in relianceonthe contents of this information is strictly prohibited. Althoughwehave taken reasonable precautions to ensure no viruses are presentinthis email, we cannot accept responsibility for any loss ordamagearising from the viruses in this email or attachments. We excludeanyliability for the content of this email, or for the consequences ofanyactions taken on the basis of the information provided in this emailorits attachments, unless that information is subsequently confirmedinwriting. If this email contains an offer, that should be consideredasan 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/
