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]
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 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
datawindowyg lagi running..(pake getsqlselect tadi)
hehe ini cuman karena ribett aja kalo kudu trace sqlnya, trus ane
kuducopas sqlnya trus kudu replace atu2 nama argumennya dengan
nilaisebenarnya.
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:[email protected])
YMID. zulmach
Website. www.zulmach.wordpress.com (http://www.zulmach.wordpress.com)
www.pemulapb.wordpress.com (http://www.pemulapb.wordpress.com)
On Thu, May 26, 2011 at 12:43 PM, Gunawan,PE (Peter) <[email protected]
(mailto:[email protected])>wrote:
Kalo bolehbantu jelasin:
Di PB kanada GetSQLSelect, nah kalo query kita ternyata pake retrieval
argumen,query yang didapat dari GetSQLSelect itu berupa query mentah
tanpavalue dari retrieval argumennya.
Misal datawindowdengan argumen tgl : 24-mei-2011
Nah yang bro Her mau,supaya value 24-mei-2011 itu juga berhasil
terambil bersama denganquery select nya.
Sementara kalo hanyadengan GetSQLSelect itu tanpa valuenya, tapi hanya
nama variableretrievalnya.
-peter-
From: [email protected]
(mailto:[email protected])[mailto:[email protected]
(mailto:[email protected])]
On Behalf Of WarasMad
Sent: Thursday, May 26, 2011 12:33 PM
To: [email protected]
(mailto:[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] (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...
-------------------------------------
This email(including any attachments to it) is confidential, legally
privileged,subject to copyright and is sent for the personal attention
of theintended recipient only. If you have received this email in
error,please advise us immediately and delete it. You are notified
thatdisclosing, copying, distributing or taking any action in reliance
onthe contents of this information is strictly prohibited. Although
wehave taken reasonable precautions to ensure no viruses are present
inthis email, we cannot accept responsibility for any loss or
damagearising from the viruses in this email or attachments. We exclude
anyliability for the content of this email, or for the consequences of
anyactions taken on the basis of the information provided in this email
orits attachments, unless that information is subsequently confirmed
inwriting. If this email contains an offer, that should be considered
asan invitation to treat.
-------------------------------------
