Forums

I tried modifying the Info Class as such but it still doesn't work:

Public Property ApplyENJPT() As Boolean

Get

Return _applyENJPT

End Get

Set(ByVal Value As Boolean)

_applyENJPT = Null.NullBoolean 'Trying this out

End Set

End Property

ah, sorry read the code too quick and didn't realise that your second constructor "Public Sub New(ByVal applyENJPT As Boolean)" was how you would set true/false. AFAIR you can't see the null values in the constructor, you can only set non-optional values. If you need to change the value then you call the public property. That way the initial start state is always null, and can be switched. In your case where you only have 1 value that is optional, you only need the default constructor with no parameters (i.e. the first sub new()). If your class had a mixture of mandatory and optional values, you would create constuctor(s) that only receive mandatory values as parameters and default the optional ones to their Null.* equivalents.

I'd recommend that you take a look at Components\Providers\Scheduling\ScheduleHistoryItem.vb and follow it's logic through as it contains an optional boolean (Succeeded).

Cathal

BEAUTIFUL!  It works great.  Thanks Cathal.  Now to recap in case someone has the same issue.

Goal:  Have an InfoObject with boolean properties such that null boolean values are passed to the database Table when those boolean properties are null otherwise pass true or false.

Solution: Construct the Info Object boolean property as shown below and make sure the SqlDataProvider does in fact wrap the parameter with the GetNull() method.

INFO OBJECT CLASS

Public Class ScheduleHistoryItem

Public Sub New()

End Sub

Public Sub New(ByVal objScheduleItem As ScheduleItem)

Me.AttachToEvent = objScheduleItem.AttachToEvent

Me.CatchUpEnabled = objScheduleItem.CatchUpEnabled

End Sub

Public Property Succeeded() As Boolean

Get

Return _Succeeded

End Get

Set(ByVal Value As Boolean)

End Set

End Property