Re: Witango-Talk: incl. Empty

[Roland Dumas]

so if the sumitted field is null, it will it will overwrite everything  
in the db, right?

On Dec 6, 2003, at 3:42 PM, Walker, Buddy wrote:

Roland
  Say you were updating a record based on the socsec.
  If you checked include if empty then the update would be (I assuming  
that socsec would not be null)

  UPDATE tableName SET columnName = 25 WHERE SocSec IS NULL

  Otherwise you would update all the records because the WHERE clause  
would not be there.

  UPDATE tableName SET columnName = 25

Buddy



    -----Original Message-----
        From: Roland Dumas [mailto:[EMAIL PROTECTED]
        Sent: Sat 12/6/2003 2:36 PM
        To: WiTango List
        Cc:
        Subject: Witango-Talk: incl. Empty
        
        
	pls clarify what this field does on a record update?
	
	set the match criteria to something (unique) and then the Incl. Empty
	field is either true or false. What does this do?
	
	 
_______________________________________________________________________ 
_
	TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
	

_______________________________________________________________________ 
_TO UNSUBSCRIBE: Go to  
http://www.witango.com/maillist.taf<winmail.dat>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf