Dear Nurdin dan farid anywhere, Error "Insufficient key column information for updating" salah satunya dan yang paling banyak terjadi adalah karena tabel yang mau di UPDATE, DELETE tidak mempunyai Primary Key. Solusinya : Buatkan Primary Key untuk Table Tersebut sebelum menjalankan Perintah Update,Delete.
Query sebelum Update ada baiknya seperti ini : SELECT * FROM Login WHERE LoginId = 123. Agar Record yang akan diupdate hanya menunjuk pada satu record. Hal ini untuk mencegah error : Multiple Step OleDB bla bla... Regards, Harisiswoyo Nurdin <[EMAIL PROTECTED]> wrote: To: <[email protected]> From: "Nurdin" <[EMAIL PROTECTED]> Date: Wed, 5 Dec 2007 14:33:35 +0700 Subject: RE: [Programmer-VB] BIsa bantuin proses edit yang error sql = "select * from login and userid like ' " & txt_NIP.Text & " ' " harusnya : sql = "select * from login Where userid like ' " & txt_NIP.Text & " ' " --------------------------------- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of farid anywhere Sent: Wednesday, December 05, 2007 5:12 AM To: [email protected] Subject: [Programmer-VB] BIsa bantuin proses edit yang error Dear all VB master, saya mau nanya masalah proses edit yang bingung, di form yang lain jalan tapi disini koq error, kira-kira apa ya...? If conn.State = adStateOpen Then conn.Close cls_pub.connect_db If rsuplog.State = adStateOpen Then rsuplog.Close rsuplog.CursorLocation = adUseClient sql = "select * from login and userid like ' " & txt_NIP.Text & " ' " rsuplog.Open sql, conn, adOpenKeyset, adLockOptimistic If rsuplog.RecordCount <> 0 Then With rsuplog .Fields(0) = txt_NIP.Text .Fields(1) = txt_pwd.Text .Fields(3) = cmb_Hak.Text .Fields(2) = txt_nama.Text .Update End With End If Pesan errornya seperti ini "Insufficient key column information for updating or refreshing". Atas jawaban rekan-rekan sekalian , makasih banyak ya.... __________________________________________________________ Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/ --------------------------------- Never miss a thing. Make Yahoo your homepage.
