Pakenya Select Top 1 ID, TglIn, JamIn
>From Tabel Where ID='" & .Fields("ID") & "'"
--- Gege Nugroho <[EMAIL PROTECTED]> wrote:
> Guys...
> Gwe punya masalah lage (yang kesekian kalinya
> :-)....)
>
> Kondisi Gwe gini:
> Pake Visual Basic 6.0 SP 6.0 ActiveX
> Database MySQL 5.0
> Tanpa komponent ADODC
>
> Saat nyimpen gwe punya data :
> ID TglIn JamIn
> 01 2008-02-20 15:00:00
> 01 2008-02-20 15:01:59
>
> Nah gwe mau data itu yang kesimpen cuman satu ajah
> (yang mana ajah) dengan statement ini, malah masuk
> dua-duanya : xM = "Select Distinct ID, TglIn, JamIn
> From Tabel Where ID='" & .Fields("ID") & "'"
>
> Kalo gwe pake ini, data ngga masuk sama sekali :
> xM = "Select Distinct ID, TglIn From Tabel Where
> ID='" & .Fields("ID") & "'"
>
> Juga kalo pake ini, ngga masuk juga : xM = "Select
> Distinct ID From Tabel Where ID='" & .Fields("ID") &
> "'"
>
> Jadi intinya bagaimana menggunakan statement
> SELECT DISTINCT ini dimana hanya menyortir satu data
> ID dan TGLIN ajah.
>
> Ato ada statement lain yah?
> Trims yo...
>
> PS : Sori kalo tatabahasa gwe rada njelimet...
> hehehe
>
> dariyangbingungngambilsatudata
>
>
> Regards
> Gege Nugroho
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with
> Yahoo! Mobile. Try it now.
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
