Re: [Programmer-VB] Update with Null

[Padu Arsana W]

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.