Hi,

I have a TypedView, and the following expression returns duplicate rows, despite that I set the AllowDuplicate parameter to false:

dim query as new MyTypedView

MyAdapter.FetchTypedView(query.GetFieldsInfo, query, False)

Interestingly, when I use a predicateexpression for one of the fields, (ComparisonOperator.Equal), I get the resultset without duplicates.

What am I missed?

Thanks

Gabor

Found the error,

I used the same typedview object twice in the dataadapter.FetchTypedView method.

Apologize

Thanks

Gabor

Glad you solved it, Gabor.

The reason the typed view isn't cleared before the fetch is that there might be a reason for fetching extra rows into an already fetched view. So you have to clear a typed view first before fetching it again if you want to fill it with new data but don't want to keep the old data around