Bukannya GetSQLSelect itu hnya hanya mengambil definition nya saja dari SQL statement yg dipakai dw? jd mmg sgt harfiah/apa adanya krn 'definition' tadi
kl mau ambil variable yg disend ke dw.retrieve, berarti hrs mengambil kombinasi dari GetSQLSelect + variable yg dikirim secara bersamaan saat eksekusi kalau dw tidak dieksekusi kan sudah tentu variable value tidak pernah ada spt yg ditanyakan oleh bung Zulmach, tergantung dari skenarionya spt apa dulu Salam ________________________________________ From: [email protected] [[email protected]] On Behalf Of Hermawan Dephe [[email protected]] Sent: Thursday, May 26, 2011 12:50 PM To: [email protected] Subject: Re: Bls: [indopb] GetSQLSelect with paramater value wadewww.. kagak jelas ya gan? maap maap... pernah pake perintah gini gak gan? (anggap masih pake datawindow tadi yg email sebelumnya) dw_1.retrieve('001') ls_sql = dw_1.GetSQLSelect ( ) hasilnya variabel ls_sql = "SELECT * FROM MEMBER WHERE NO_ID = :ls_noid" bisa gak sih PB skalian dapetin nilai argumennya sehingga jadinya ls_sql = "SELECT * FROM MEMBER WHERE NO_ID = '001' " kasus ini karena, ane punya beberapa datawindow dengan banyak argumen gan.. ada yg lebih dari 6 argumen.. cape aja kan mo trace SQLnya kudu ketik2 atu2. jadi ane jalanin saat runtime dengan perintah ini, setelah dapetin syntax sqlnya ane copas & execute dah.. Waras Mad wrote: 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... The information contained in this email including any files transmitted are confidential and intended solely for the use of the individual or entity to whom they are addressed. They may contain legally privileged information, and may not be disclosed to anyone else. If you are not the intended recipient(s), you are hereby notified that any distribution or copying of this e-mail message is strictly prohibited and please delete any copies from your system. In case any content of this e-mail message does not relate to the official business of the domain owner(company), it should be deemed and understood as neither given nor endorsed by the domain owner (company). Thank you. ------------------------------------ ----------------------------------------------- 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/
