DevForce Community Forum : Setting NULL into a column http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Setting NULL into a column Sat, 11 Apr 2026 12:38:24 -700 Wed, 04 Feb 2009 10:45:10 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1074 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Setting NULL into a column : Good question. The schedule is... http://www.ideablade.com/forum/forum_posts.asp?TID=1074&PID=3863#3863 Author: kimj
Subject: 1074
Posted: 04-Feb-2009 at 10:45am

Good question.  The schedule is currently under discussion, but it will be 2 - 6 weeks (with engineering voting for 2 weeks).  I'll post again once we have a firm date, or you can contact support directly if I'm remiss.]]> Wed, 04 Feb 2009 10:45:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1074&PID=3863#3863 Setting NULL into a column : OK, for the time being I'll... http://www.ideablade.com/forum/forum_posts.asp?TID=1074&PID=3862#3862 Author: dkearney1
Subject: 1074
Posted: 04-Feb-2009 at 10:40am

OK, for the time being I'll add records to the FundSource table that represent the lack of a fund source and wait for the fix.

How tentative is "tentatively scheduled" ?]]> Wed, 04 Feb 2009 10:40:12 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1074&PID=3862#3862 Setting NULL into a column : Dan, Sorry, your first post... http://www.ideablade.com/forum/forum_posts.asp?TID=1074&PID=3861#3861 Author: kimj
Subject: 1074
Posted: 04-Feb-2009 at 9:41am

Dan, 

Sorry, your first post somehow slipped by us.
 
This problem is actually due to a bug, which we fixed in early January.  Unfortunately, we haven't had a release since December, so this is no help to you right now.  The next release is tentatively scheduled for late this month (February). 
]]> Wed, 04 Feb 2009 09:41:13 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1074&PID=3861#3861 Setting NULL into a column : Any help? http://www.ideablade.com/forum/forum_posts.asp?TID=1074&PID=3859#3859 Author: dkearney1
Subject: 1074
Posted: 04-Feb-2009 at 5:55am

Any help?]]> Wed, 04 Feb 2009 05:55:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1074&PID=3859#3859 Setting NULL into a column : I can't believe I'm... http://www.ideablade.com/forum/forum_posts.asp?TID=1074&PID=3845#3845 Author: dkearney1
Subject: 1074
Posted: 28-Jan-2009 at 12:05pm

I can't believe I'm not getting this.

I've got a table ContractFunds, with a nullable column FundSource, which refers to a FundSource table. The ServerModel and DomainModel entities exist and have no interesting bits.

I create ContractFund record by hand, having NULL in the FundSource column, and having retrieved this record via IdeaBlade, the FundSource property is (correctly) a NullEntity (IsNullEntity == true). I continue by retrieving an appropriate FundSource, set it into the ContractFund, save, and the record in the database is updated. Now I want to undo that last action. I retrieve the ContractFund, set the FundSource to null, which appears to have the desired effect, but after the save the record in the database still has a value in the FundSource column. I know the save worked because the housekeeping columns have updated. When I crank up the Profiler, the update statement shows the housekeeping columns being updated, but the changes to the FundSource column aren't there.

Here's the code:
     Contract testContract = Contract.Get(em, 7);
     ContractFund fund = testContract.ContractFunds[0];
     FundSource fundSource = fund.FundSource;

     if (fundSource.EntityAspect.IsNullEntity)
     {
          FundSource newSource = FundSource.Get(em, "FAA");
          fund.FundSource = newSource;
     }
     else
     {
          fund.FundSource = null;
     }

     if (em.HasChanges())
          em.SaveChanges();

What am I missing?]]> Wed, 28 Jan 2009 12:05:50 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1074&PID=3845#3845