FW: [Programmer-VB] Syntax error in UPDATE statement.

[Ferrr_xls]

Ada kesalahan syintax query sebelum clause Where ada koma (“,”)  coba dihapus   cnn.Execute "update Table1 SET " & _ " SETORANAIRLINES = '" & txtSetAirlines &  _ " WHERE PESAWAT = '" & cboPesawat & "' and RUTE1= '" & txtDari & "' and RUTE2= '" & txtTujuan & "' AND CLASS= '" & txtKelas & "'"   Dicoba ya  !!! Semoga membantu ya !! From: Programmer-VB@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of dhanang apris Sent: 12 Juli 2006 14:44 To: Programmer-VB@yahoogroups.com Subject: Re: [Programmer-VB] Syntax error in UPDATE statement.   kayaknya sih sintaknya OK kecuali tanda "," sebelum where itu lho... Frangky <[EMAIL PROTECTED]> wrote: Teman-teman Pakar VB yang terhormat! Saya menggunakan kode dibawah ini untuk meng-update Nilai Setroran Airlines, tapi error, mungkin sintaxnya salah. Mohon koreksi dari teman-teman. Private Sub cmdUpdate_Click() cnn.Execute "update Table1 SET " & _ " SETORANAIRLINES = '" & txtSetAirlines & "', " & _ " WHERE PESAWAT = '" & cboPesawat & "' and RUTE1= '" & txtDari & "' and RUTE2= '" & txtTujuan & "' AND CLASS= '" & txtKelas & "'" End Sub     Yahoo! Music Unlimited - Access over 1 million songs. Try it free. __._,_.___ 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  Visit your group "Programmer-VB" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. __,_._,___