Kl aku lihat datanya, memang agak susah untuk mencari metode urut data seperti yang diinginkan.
Keculai mungkin ditambah field baru ( numeric) sebagai urutan sesuai dengan yang kita inginkan. Misalnya tambah field Urut, nanti bikin perulangan selama data sumber masih ada, urut tadi tambahkan 1 pada setiap update record. Nah..field itu yang nantinya menjadi sumber pengurutan. Kira2 begitu saran saya, apa bisa diterapkan pada kasus ini ? Rgd, --- Eko <[EMAIL PROTECTED]> wrote: > maaf mas purwedi, klo cara itu sdh saya coba > tapi cb mas perhatikan kondisi field Hd dan field > Urut > > saya ingin membalik urutan data tsb karena klo > urutannya tdk dibalik maka ketika akan ditransfer ke > tabel lain > maka yang terjadi data di tabel baru lah yg terbalik > > proses transfernya kira2 begini (mohon koreksi) > For I = 1 To rsPBBDD.RecordCount > rsPPBD.AddNew > rsPPBD!No_PPB = NoBaru > rsPPBD!HD = rsPBBDD!HD > rsPPBD!urut = rsPBBDD!urut > rsPPBD!BARANG = rsPBBDD!KD_BRG > rsPPBD!QTY = rsPBBDD!QTY > rsPPBD!SATUAN = rsPBBDD!SATUAN > rsPPBD!KD_CAT = rsPBBDD!KD_CAT > rsPPBD!Ket = rsPBBDD!Ket > rsPPBD.Update > rsPBBDD.MoveNext > Next I > > ----- Original Message ----- > From: Purwedi Kurniawan > To: [email protected] > Sent: Friday, February 24, 2006 9:28 AM > Subject: Re: [Programmer-VB] membalik urutan data > (Urgen) > > > tambahkan diakhir query: ORDER BY > namafield1,namafield2 dst DESC > > > On 2/24/06, Eko <[EMAIL PROTECTED]> > wrote: > saya punya data dari > select * from pbbdd where No_PBBD like > 'PBBD/02/2006' > > No_PBBD Hd Urut Kd_Brg > Ket > PBBD/02/2006 k 1 BL/PEB/001 > PBBD/02/2006 n > Cadangan > PBBD/02/2006 k 2 3ES/004 > PBBD/02/2006 k 3 3ES/014 > PBBD/02/2006 n > perawatan > > gimana caranya membalik urutan data tersebut > menjadi > > No_PBBD Hd Urut Kd_Brg > Ket > PBBD/02/2006 n > perawatan > PBBD/02/2006 k 3 3ES/014 > PBBD/02/2006 k 2 3ES/004 > PBBD/02/2006 n > Cadangan > PBBD/02/2006 k 1 BL/PEB/001 > > > > > Wahana Programmer Groups Links > > > > > > > > SPONSORED LINKS Programmer Indonesia Basic > programming language > Computer programming languages Programming > languages Java programming language > > > ------------------------------------------------------------------------------ > YAHOO! GROUPS LINKS > > a.. Visit your group "Programmer-VB" on the > web. > > b.. To unsubscribe from this group, send an > email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > ------------------------------------------------------------------------------ > > __________________________________________________ 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 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/
