sama aja di datawindow pasti bisa asal buatnya dgn dsign time. pake mode text -- convert to text -- leluasa buanget.
klu pake run time, modify datawindow untuk sqlsyntax nya suka gagal klu ada case when -nya --- mellon <[EMAIL PROTECTED]> wrote: > thank Om untuk pencerahannya, > > yang pertama akan kucoba dulu yah. > > yang kedua aku kok kurang sreg..ya. > misalnya kita waktu membuat datawindow pada > PowerBuilder dgn database oracle > ,syntax sqlnya spt ini contohnya : > > select decode(job_title,'Supervisor', decode ( > sex,'Male','OKE'),'TIDAK > OKE') > from emp_tabel ; > > nah bagaimana syntaxnya jika membuat datawindow pada > PowerBuilder dgn > database sql server? > kalo memakai case..when...Then...else...end bukannya > di PBnya bukan di > datawindownya > > > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] Behalf Of > darma > Sent: Thursday, May 25, 2006 8:00 PM > To: [email protected] > Subject: Re: [indopb] tanya format date dan fungsi > jika di MSSQL > > > > yg kedua: > biasa sech case ... when .. Then ... else ... end > ga tau klu ada yg lbh simple. > > oh yach .. yg pertama itu klu SQL embedd di PB ga bs > lho .. plg biasa kita akalin pake SP > > > > > __________________________________________________ > Apakah Anda Yahoo!? > Lelah menerima spam? Surat Yahoo! memiliki > perlindungan terbaik terhadap spam > http://id.mail.yahoo.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get to your groups with one click. Know instantly when new email arrives http://us.click.yahoo.com/.7bhrC/MGxNAA/yQLSAA/NhFolB/TM --------------------------------------------------------------------~-> ----------------------------------------------- IndoPB - Indonesia PB User Group Learn PB6 by download FasTrack to PB6 at : http://groups.yahoo.com/group/indopb/files/Belajarpb6/ To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> 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/
