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.
________________________________
