Hi,

I want to query a typedview, where two fields doesn't equals, like the following SQL:

Select * from Orders where employeeID <> administratorID

dim bucket as new RelationPredicateBucket

bucket.PredicateExpression.add(new FieldCompareExpressionPredicate(entityFieldFactory.Create( _ MyTypedViewFieldIndex.EmployeeID), _ ComparisonOperator.NtEqual, _ New Expression(EntityFieldFactory.Create( _ MyTypedViewFieldIndex.AdministratorID))))

But I get the InvalidCastException error.

For the entire FieldCompareExpressionPredicate on writes in the debugger, th following error: "Cannot convert to Interface IEntityField".

Thanks

Gabor

change: MyTypedViewFieldIndex.EmployeeID), _ into: MyTypedViewFieldIndex.EmployeeID), Nothing, _

You're using the SelfServicing overload.

You can also use the PredicateFactory

Thanks, it works great!

Gabor