Hi all,

I can return the number of rows in table Section via:

relCount = Cint(adapter.GetScalar(SectionFields.DivisionCode, AggregateFunction.Count))

When I try to apply a filter on DivisionCode, where aDivID contains a value, via:

Dim filter as New PredicateExpression()
filter.Add(SectionFields.DivisionCode = aDivID)
relCount = Cint(adapter.GetScalar(SectionFields.DivCode, null, AggregateFunction.Count, filter))

It declares that null is no longer supported and to use 'System.DBNull' instead. When I do that overload resolution fails.

I'm using the latest LLBLGen Pro, VB, VS2005 & Adapter and I only want to return the number of rows where DivisionCode = the value of aDivID. Can anyone see what I might be missing

Thanks

Shouldn't "null" be "Nothing" in VB?