Sorry, mungkin saya salah cara ngomongnya. Maksud saya, tabel LoginHistory saya sudah ada datanya seperti ini:
UserID, Password, LoginTimeStart root, root, 2003-07-15 17:00:00 gatut, ge, 2003-07-20 07:30:15 gatut, ge, 2003-07-22 09:28:00 root, root, 2003-07-24 13:00:01 ... Nah, bagaimana SQL command utk menghasilkan daftar setiap UserID dengan waktu TERAKHIR mereka login? Hasil yang saya inginkan seperti ini: UserID, Password, LoginTimeStart gatut, ge, 2003-07-22 09:28:00 root, root, 2003-07-24 13:00:01 ... Database yang dipakai Oracle 8. Thanx in advance, -gatut- ----- Original Message ----- From: "Handy Novianto" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2003 5:14 PM Subject: Re: [Delphindo] HELP: SQL command > kalo dengan menggunakan adoquery dan database nya mssql2000 bisa di > gunakan perintah berikut yg dijalankan pada saat tombol login di > klik > > query:= update LoginHistory set LoginTimeStart = getdate() WHERE UserID ='namauser'; > adoquery1.sql,clear; > adoquery1.sql.add (query); > adoquery.sql.exec; > > smoga bisa mmbantu, mungkin delphier yg laen bisa mmbantu dengan > adotable misalkan ? > > > Best Regards... > -- > Handy Novianto <[EMAIL PROTECTED]> > > > > Berlangganan: [EMAIL PROTECTED] > Stop Berlangganan: [EMAIL PROTECTED] > Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ > > ------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy Toner for Your Printer or Fax at LaserTonerSuperstore.com-Save 55%! We have your brand: HP, IBM, Canon, Xerox, Apple and many more for less! http://www.LaserTonerSuperstore.com http://us.click.yahoo.com/YmQqWC/qicGAA/ySSFAA/i7folB/TM ---------------------------------------------------------------------~-> Berlangganan: [EMAIL PROTECTED] Stop Berlangganan: [EMAIL PROTECTED] Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
