Non-Nullable column cannot be updated to Null...

[rickyoswaldiow]

Good afternoon all. I am having some trouble with my save function. The problem is that when the program loads and the controls are populated, two of my DataCombos are acting strange. I have 10 of these DataCombos and they are all loaded in exactly the same way, one after the other:

        frmCompanyDetails.cboDefaultCustAnaCodeFrom.BoundText = !DefaultCustAnaCodeFrom
        If !CustAnaCodeCompulsory = True Then frmCompanyDetails.chkCustAnaCodeCompulsory = 1
        If !CustAnaCodeCompulsory = False Then frmCompanyDetails.chkCustAnaCodeCompulsory = 0
        frmCompanyDetails.cboCustFixedAna.BoundText = !CustFixedAna
        
        frmCompanyDetails.cboDefaultSOAnaCodeFrom.BoundText = !DefaultSOAnaCodeFrom
        If !SOAnaCodeCompulsory = True Then frmCompanyDetails.chkSOAnaCodeCompulsory = 1
        If !SOAnaCodeCompulsory = False Then frmCompanyDetails.chkSOAnaCodeCompulsory = 0
        frmCompanyDetails.cboSOFixedAna.BoundText = !SOFixedAna
        
        frmCompanyDetails.cboDefaultProjAnaCodeFrom.BoundText = !DefaultProjAnaCodeFrom
        If !ProjAnaCodeCompulsory = True Then frmCompanyDetails.chkProjAnaCodeCompulsory = 1
        If !ProjAnaCodeCompulsory = False Then frmCompanyDetails.chkProjAnaCodeCompulsory = 0
        frmCompanyDetails.cboProjFixedAna.BoundText = !ProjFixedAna
        
        frmCompanyDetails.cboDefaultSuppAnaCodeFrom.BoundText = !DefaultSuppAnaCodeFrom
        If !SuppAnaCodeCompulsory = True Then frmCompanyDetails.chkSuppAnaCodeCompulsory = 1
        If !SuppAnaCodeCompulsory = False Then frmCompanyDetails.chkSuppAnaCodeCompulsory = 0
        frmCompanyDetails.cboSuppFixedAna.BoundText = !SuppFixedAna
        
        frmCompanyDetails.cboDefaultPurchAnaCodeFrom.BoundText = !DefaultPurchAnaCodeFrom
        If !PurchAnaCodeCompulsory = True Then frmCompanyDetails.chkPurchAnaCodeCompulsory = 1
        If !PurchAnaCodeCompulsory = False Then frmCompanyDetails.chkPurchAnaCodeCompulsory = 0
        frmCompanyDetails.cboPurchFixedAna.BoundText = !PurchFixedAna

It's just the last one that is not working. I have stepped through the program and can tell you that !DefaultPurchAnaCodeFrom has data in it in a similar format to all the others but for some unknown reason the DataCombo refuses to populate...

 

[JoeAtWork]

Well, your error message in the subject line is telling you that you are trying to assign a null value to a field that doesn't allow Nulls.

So I would check if the field that cboPurchFixedAna is bound to does not allow Nulls, and if the value of !PurchFixedAna is Null. If both are true, then there's your problem.

 

[rickyoswaldiow]

I went through my database and put in default values as a work around, this didn't seem to have any effect (wierd). I found the problem though - The last pair of combos were being populated from the wrong source!