Dear McBoen,
Coba petiknya dibetulkan hayooo. Coba dulu 15 menit sampe betul baru kalo belum betul posting lagi ..... hehehe. Pasti bisa deh. Hint : petik dua di VB harus digandakan, jadi : " = "" Best Regards, Dhani Aristyawan, S.Kom. EDP Supervisor PT. Trias Sentosa, Tbk. Desa Keboharan KM 26 Krian - Sidoarjo _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of McBoenBoen Sent: Thursday, September 07, 2006 4:22 PM To: [email protected] Subject: RE: [indoprog-vb] Cara Update SQL saya sudah coba di Query berhasil mas, cuma kl saya pake di VB masih ada eror ya kursis selalu nunjuk "d"... ada yg kurang dari scrip dibawah? cn.Execute ("update t_tagihan Set flag = case " & _ "' when (abs( datediff( "d", tgl_tagihan, getdate() ) ) <= 15) and (status ='Proses') then 'Warning 1'" & _ "' when (abs( datediff( "d", tgl_tagihan, getdate() ) ) <= 30) and (status ='Proses') then 'Warning 2'" & _ "' when (abs( datediff( "d", tgl_tagihan, getdate() ) ) >= 45) and (status ='Proses') then 'Warning 3'" & _ End rgds, mc "Dhani Aristyawan (EDP)" <[EMAIL PROTECTED] <mailto:dhania%40trst.co.id> co.id> wrote: New Message Search Find the message you want faster. Visit your group to try out the improved message search. Share feedback on the new changes to Groups Recent Activity 27 New Members 1 New Files Visit Your Group SPONSORED LINKS Texas driver education Computer telephony Christian education Portable computer Education . --------------------------------- How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/SktRrD/hOaOAA/yQLSAA/zCsqlB/TM --------------------------------------------------------------------~-> Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Bagi terjangkit virus lokal, zip virus tersebut dan kirim ke [EMAIL PROTECTED], kami akan membuat removalnya untuk anda. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> 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/
