InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 05:50:33 GMT20http://forum.strataframe.net/FindPost12008.aspxI have been playing with the settings in the BO Mapper for the NULL Value Options.&nbsp; What I want to accomplish is this...<BR><BR>1.&nbsp; Get values with the replacement value applied if a null is in the db.&nbsp; i.e. Get out a "" for a NULL string value.</P><P>2.&nbsp; I want to be able to control what values are going back into the database.&nbsp; Sometimes a NULL means different things than a "" string value or a 0 decimal value.&nbsp; Is there some way to control how it puts it back in, but always return it with the replacement value applied?Tue, 16 Oct 2007 09:18:09 GMTAndria Jensenhttp://forum.strataframe.net/FindPost12022.aspx1) The replacement value options are designed for exactly that... you can use String.Empty or "" for the replacement value.</P><P>2) There is an option for returning a replacement on null and setting null on the replacement.&nbsp; If you use "" for the replacement and try to set that as the value, the property will set NULL back to the database.&nbsp; However if you want to differentiate between NULL and "", then you'll most likely have to use the CurrentRow property on the business object to set null values back.&nbsp; bo.CurrentRow("field") = DBNull.Value will do the trick and bypass the strong-typed property.Tue, 16 Oct 2007 09:18:09 GMTStrataFrame Team