Will do, I didnt think this step was required since I hadn't done it before, for now I'll take the bandaid but I will try to find the original problem also.

Keith Chisarik

The solution will prevent the error, but is not the cause of the error.  You actually should not have to do this.  From what I understand, you are creating a new record.  At this point, the database type has no relavance as all of this is intrinsic to the BO.  So it would appear that when you are adding a record the fields are not being initialized...and/or you are referencing this field either through a manual binding, event, or some other code before it gets initialized.

By default, a BO has the AllowNullValuesONnewRow set to false, which forces all rows to be initialized with a default value when a new row is created.  So the NULL is not coming from there...it is happening in the Get of the strong-typed property which means that something is trying to call a GetValue before it is initialized.

You might check your mappings or place a breakpoint in the Get of the property to see what is pulling the value.  You have a "bandaid" on it so to speak and it would probably be a good idea to find the source of the issue.

Makes sense Edhy, thanks.

Keith Chisarik

Well basically that step is there to allow you to handle your specific database Null values, so you can accommodate your SF project to be compatible with any DBNull schema used.  In your particular case you don't have access to modify the database the way you want it, but that will not stop your SF project to keep working.

Just my 0.02

Edhy Rijo

Thank you both, that worked!

I'll admit I am confused why that step was necessary, but I'll save that for another day, unless someone is feeling like enlightening

Keith Chisarik

Hi Keith,

In the BO Mapper, just double click the field you want to modify and on the right side of the Custom Field Properties, set the NULL  Value Option to "Return Alternate on Null" or any other that apply to your case.

Edhy Rijo

Is that feature under "Customize" in the mapper? I cant find it elsewhere and for some reason "Customize" and "Clear" are greyed out and the customization wizard bombs out on me. 

NullReferenceException
  Object reference not set to an instance of an object.

Source     : MicroFour StrataFrame AddIns

Stack Trace:
   at MicroFour.StrataFrame.AddIns.DTEprojectsBO.FillProjects(String[] ProjectPaths)
   at MicroFour.StrataFrame.AddIns.PartialClassBuilderCustomizeWizard.ᜀ(ᜏ A_0)
   at MicroFour.StrataFrame.AddIns.PartialClassBuilderCustomizeWizard.ᜀ()
   at MicroFour.StrataFrame.AddIns.PartialClassBuilderCustomizeWizard.OnLoad(EventArgs e)

Keith Chisarik

No, both columns are set to disallow NULL. I will try your suggestion now. Thanks.

Keith Chisarik

Hi Keith,

You could try "Return alternate.." in the BO mapper and set the alternate to "String.Empty".

Do you need to be able to store nulls in that column in database? We don't allow any database column to be nullable unless it is absolutely necessary.

Cheers, Peter

I should add I'm on 1.6.5

Keith Chisarik