RE: [Programmer-VB] Update with Null

[Andhi Y]

Thanks mas Padu Arsana, udah bisa, ternyata cuma ditambahin tanda kutip doang toh…   From: Padu Arsana W [mailto:[EMAIL PROTECTED] Sent: Tuesday, 02 May 2006 11:01 AM To: Programmer-VB@yahoogroups.com Subject: Re: [Programmer-VB] Update with Null   Coba ubah ,null,  jadi "null"    cn.Execute "Update MsBarang Set Harga=" & IIf(Text1.Text = "", "Null", Text1.Text) & " Where Kode='01333'"   Salam Padu Arsana W     CN.Execute "Update tbl_MasterStock Set HrgBeli=" & IIf(txthrgbeli.Text = "", "Null", txthrgbeli.Text) & " Where NoSeri='122222'" Andhi Y <[EMAIL PROTECTED]> wrote: Teman2,   Kenapa ya kalo saya mau update dan isinya akan null jika Text1 tidak mempunyai isi maka keluar pesan : “syntax error in UPDATE Statement”   Script yg saya jalankan: cn.Execute "Update MsBarang Set Harga=" & IIf(Text1.Text = "", Null, Text1.Text) & " Where Kode='01333'"   Bagaimana supaya nilainya itu adalah Null? databasenya adalah Access   Thanks B4       Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. 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 SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language 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.