ga bisa, kayaknya jawaban saya ga bisa melulu... coba pake recordset aja, pilih record yang mau dihapus, waktu mau delete move next dulu sekali trus simpen nomor id nya trus move previous sekali trus delete ...
atau coba: select top 1 id from table_ku where nama>'Bendol' order by nama desc saya jg blom coba kalo select diatas, kalo ga salah di mysql bisa perbandingan karakter mungkin di mssql bisa jg CMIIW dah... --- UniqueDream <[EMAIL PROTECTED]> wrote: > ID Nama > 7 Bendolet > 6 Bendol > 2 Bonang > 9 Embe > 1 Paijo > 8 Stutejo > > thx bro hendikin atas saran sebelumnya, tapi ada > masalah muncul, jika dilakukan pengurutan > berdasarkan field Nama, kemudian jika ID = '2' > dihapus, apakah bisa kita memperoleh return id = '9' > thx atas bantuannya, maaf sering tanya, masih newbie > di pemrograman windows... > > mohon pencerahan > > ----- Original Message ----- > From: Hendikin Ferrar > To: [email protected] > Sent: Tuesday, March 07, 2006 2:03 PM > Subject: RE: [Programmer-VB] Get no ID di SQL > > > udah coba statement ini? > > select top 1 id from table_ku where id>2 order by > id desc > > a.. Best regards, > b.. Hendikin Ferrar > c.. PT. ERPSoft Solusi Mandiri > d.. The Information Technology Company > e.. http://www.erpsoft.co.id > > > > > ------------------------------------------------------------------------------ > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of > UniqueDream > Sent: Tuesday, March 07, 2006 1:18 PM > To: [email protected] > Subject: [Programmer-VB] Get no ID di SQL > > > saya mau tanya > misalkan data saya > > ID Nama > 1 Paijo > 2 Bonang > 3 Bendolet > 4 Bendol > 5 Embe > > misalkan saya menghapus data dengan ID = '2' > setelah dihapus, > bagaimana cara nya agar saya memperoleh data > return ID = '3' ? > > delete * from table_ku where id = '2' > > trus yang diinginkan... > set @return_id = '3' -> id dibawah data yang > dihapus > > mohon pencerahan.... thx b4 > ___________________________________________________________ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.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/
