Saya bikin Aplikasi Di win 2003 dan memakai smartnetbutton.ocx... kenapa pas di Win XP error ya... yang ada tombol "Send Error" dan "Dont Send Error"
tapi pas smartnetbuttonnya di ganti dengan bawaan standar VB6...jadi ok ok aja.. pertanyaan saya : Apa bener yang namanya OCX third Party itu g stabil..? ----- Original Message ----- From: "Ronald Irawan" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, June 15, 2006 11:50 AM Subject: RE: [Programmer-VB] Tanya Select Distinct > Jam jgn dibawa lagi > Select Kode, Rinician, User, Tgl, sum(jam) as hour FROM DETAIL group by > Kode, Rinician,User, Tgl > > Salam > Ronald Irawan > Pt. Sanghiang Perkasa > Gd. Graha Kirana Lt.5 > Jl Yos Sudarso Kav.88 > Jakarta > > > > De ce <[EMAIL PROTECTED]> > Sent by: [email protected] > 15/06/2006 11:42 AM > Please respond to > [email protected] > > > To > [email protected] > cc > > Subject > RE: [Programmer-VB] Tanya Select Distinct > > > > > > > Mas-Mas sekalian, > > Saya sudah rubah field JAM menjadi NUMBER dan saya run dengan query: > > Select Kode, Rinician, User, Tgl, Jam, sum(jam) as hour FROM DETAIL group > by Kode, Rinician,User, Tgl, Jam order by User, Tgl > > Tapi hasilnya tetap satu-satu ya (hasil saya attach). > > USER TGL KODE RINICIAN JAM > DC 16/01/2006 7005008 OTHER DEVELOPMENT 1 > DC 16/01/2006 7005008 OTHER DEVELOPMENT 3 > DC 16/01/2006 7005008 OTHER DEVELOPMENT 4 > DC 17/01/2006 8005003 MAINTENANCE 1 > DC 17/01/2006 8005003 MAINTENANCE 4 > > Yang di harapkan hasilnya: > > USER TGL KODE RINICIAN JAM > DC 16/01/2006 7005008 OTHER DEVELOPMENT 7 > DC 17/01/2006 8005003 MAINTENANCE 5 > > Mohon bantuannya, terima kasih. > > > > "Nfs, Ibrahim" <[EMAIL PROTECTED]> wrote: > Dear De Ce, > > Kalau begitu diconvert aja mas data jamnya, baru di sum. > Select Kode, Rinician, User, Tgl, sum(cast(Jam as int)) as hour FROM > DETAIL group by Kode, Rinician, User, Tgl > Atau > Select Kode, Rinician, User, Tgl, sum(A.hour) FROM > FROM > (Select Kode, Rinician, User, Tgl, cast(Jam as int) as hour FROM DETAIL) A > GROUP BY > A.Kode, A.Rinician, A.User, A.Tgl > > Mudah-mudahan bisa membantu. > > Regards, > > Ibrahim > mailto:[EMAIL PROTECTED] > > > From: [email protected] [mailto:[EMAIL PROTECTED] > On Behalf Of De ce > Sent: Thursday, June 15, 2006 9:18 AM > To: [email protected] > Subject: Re: [Programmer-VB] Tanya Select Distinct > > Mas-mas sekalian, > > Saya sudah coba dengan: > > Select Kode, Rinician, User, Tgl, sum(Jam) as hour FROM DETAIL group by > Kode, Rinician, User, Tgl > > Tapi keluar error 3464 - Data type mismatch in criteria expression > > Untuk informasi saja field JAM itu bukan number tapi text apa harus saya > rubah ke number ya? (maaf ini tabel warisan) > > Trims. > > tahar dn <[EMAIL PROTECTED]> wrote: > Kayaknya nya begini sintak sqlnya : > > "select code,act,user,date,sum(hour) hour from ..... group by > code,act,user,date > mudah-mudahan bisa > > > De ce <[EMAIL PROTECTED]> wrote: > Rekan mau tanya nih, > > Code Act User Date Hour > 0001 Administrasi Budi 14/06/2006 1 > 0002 Marketing Budi 14/06/2006 4 > 0003 Meeting Budi 14/06/2006 1 > 0001 Administrasi Budi 14/06/2006 1 > > Data di atas kode 0001 terdapat 2 transaksi dan yang ingin saya tanyakan > bagaimana command untuk bisa search sekalian filter dengan tampilan sbb: > > Code Act User Date Hour > 0001 Administrasi Budi 14/06/2006 2 > 0002 Marketing Budi 14/06/2006 4 > 0003 Meeting Budi 14/06/2006 1 > > Kalau saya menggunakan query select distinct code ... maka penjumlahan > jamnya tidak ada. Mohon bantuannya. > Terima kasih > > ME > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut: http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke: [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini: Yahoo! Messenger: wahanaprogrammer Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-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/
