Re: [indopb] GetSQLSelect with paramater value

[Hermawan Dephe]

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 datawindow yg lagi running..(pake getsqlselect tadi) hehe ini cuman karena ribett aja kalo kudu trace sqlnya, trus ane kudu copas sqlnya trus kudu replace atu2 nama argumennya dengan nilai sebenarnya. 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.      zulm...@gmail.com YMID.      zulmach Website.  www.zulmach.wordpress.com                 www.pemulapb.wordpress.com On Thu, May 26, 2011 at 12:43 PM, Gunawan, PE (Peter) <peter.guna...@rabobank.com> wrote:   Kalo boleh bantu jelasin: Di PB kan ada GetSQLSelect, nah kalo query kita ternyata pake retrieval argumen, query yang didapat dari  GetSQLSelect itu berupa query mentah tanpa value dari retrieval argumennya. Misal datawindow dengan argumen tgl : 24-mei-2011 Nah yang bro Her mau, supaya value 24-mei-2011 itu juga berhasil terambil bersama dengan query select nya. Sementara kalo hanya dengan GetSQLSelect itu tanpa valuenya, tapi hanya nama variable retrievalnya.     -peter-   From: indopb@yahoogroups.com [mailto:indopb@yahoogroups.com] On Behalf Of Waras Mad Sent: Thursday, May 26, 2011 12:33 PM To: indopb@yahoogroups.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 <wawn1...@gmail.com> Kepada: indopb@yahoogroups.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, legally privileged, subject to copyright and is sent for the personal attention of the intended recipient only. If you have received this email in error, please advise us immediately and delete it. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Although we have taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the viruses in this email or attachments. We exclude any liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided in this email or its attachments, unless that information is subsequently confirmed in writing. If this email contains an offer, that should be considered as an invitation to treat. __._,_.___ ----------------------------------------------- IndoPB - Indonesia PB User Group http://groups.yahoo.com/group/indopb Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___