DevForce Community Forum : Insert NULL Into Database Field http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Insert NULL Into Database Field Mon, 13 Apr 2026 05:26:26 -700 Fri, 30 Jul 2010 12:22:44 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2010 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Insert NULL Into Database Field : Thank you for the suggestion!... http://www.ideablade.com/forum/forum_posts.asp?TID=2010&PID=7934#7934 Author: cjohnson84
Subject: 2010
Posted: 30-Jul-2010 at 12:22pm

Thank you for the suggestion!  I was able to add a "BeforeSet" method to my injected Baseentity class to solve the problem.]]> Fri, 30 Jul 2010 12:22:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2010&PID=7934#7934 Insert NULL Into Database Field : A BeforeSet property interceptor... http://www.ideablade.com/forum/forum_posts.asp?TID=2010&PID=7884#7884 Author: davidklitzke
Subject: 2010
Posted: 28-Jul-2010 at 4:19pm

A BeforeSet property interceptor action would do the trick.  I guess you could generalize it further to any entity, and in the logic in the interceptor determine if the set should be cancelled.

 

]]> Wed, 28 Jul 2010 16:19:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2010&PID=7884#7884 Insert NULL Into Database Field : I have bound the contents of the... http://www.ideablade.com/forum/forum_posts.asp?TID=2010&PID=7825#7825 Author: cjohnson84
Subject: 2010
Posted: 27-Jul-2010 at 11:20am

I have bound the contents of the "Employees" table in my database to a datagrid in my DevForce 2010 Silverlight application.

The "MiddleName" field in the "Employees" table is defined as a Nullable Varchar(30) in the database.
 
If I edit records in the datagrid and then save back to the database how do I ensure that NULL values are written back to the database instead of empty strings for the "MiddleName" field if the "MiddleName" field was left blank in the datagrid? 
]]> Tue, 27 Jul 2010 11:20:01 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2010&PID=7825#7825