Gak usah make retrieval argument aja napa? toh nantinya where clause-nya bakalan direplace. Daripada ribet-ribet ekstrak retrieval argumennya. kang mas Hartoyo Lelaki biasa-biasa saja web site: http://www.mastoyo.tk, http://herparingan.blogspot.com
________________________________ From: gesang dr <[email protected]> To: [email protected] Sent: Thursday, May 26, 2011 3:23 PM Subject: Bls: [indopb] GetSQLSelect with paramater value [2 Attachments] [Attachment(s) from gesang dr included below] sekedar sharing, saya mempunyai function untuk menset retrievel argument melalui script di window tanpa harus menset retrieval argument dalam datawindow, biasanya saya gunakan untuk 1 datawindow yang dipakai pada window yang berbeda - beda dengan retrival argument yang berbeda pula. contoh window String ls_parm dw_1.settransobject(SQLCA) ls_parm = "WHERE TableNAME.FIELDNAME = " + retrievalargument f_replacesqldatawindow(dw_1, ls_parm) dw_1.retrieve() messagebox("a", dw_1.getsqlselect()) Regards Gesang ________________________________ Dari: "Gunawan, PE (Peter)" <[email protected]> Kepada: "[email protected]" <[email protected]> Terkirim: Kam, 26 Mei, 2011 12:43:26 Judul: RE: [indopb] GetSQLSelect with paramater value 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:[email protected] [mailto:[email protected]] On Behalf Of Waras Mad Sent: Thursday, May 26, 2011 12:33 PM To: [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]> Kepada: [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 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. ________________________________
