indra gunawan <[EMAIL PROTECTED]> wrote:
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" <ronald.irawan@kalbefood. >com
To: <Programmer-VB@yahoogroups. >com
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]com >
> Sent by: Programmer-VB@yahoogroups. com
> 15/06/2006 11:42 AM
> Please respond to
> Programmer-VB@yahoogroups. com
>
>
> To
> Programmer-VB@yahoogroups. com
> 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" <ibrahim.nfs@hp.com > 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:Ibrahim.Nfs@hp.com
>
>
> From: Programmer-VB@yahoogroups. com
[mailto:Programmer-VB@yahoogroups. ]com
> On Behalf Of De ce
> Sent: Thursday, June 15, 2006 9:18 AM
> To: Programmer-VB@yahoogroups. com
> 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]com > 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]com > 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
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__._,_.___
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
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
