lastmohican wrote:
There is a view on the oracle database. One record repeats on many rows. I have created a typedlist on llblgen designer. There are distinct records. I have 2 problems :
I give a filter to view and fetched it. For example:
filter.addfilter.AddWithAnd(ViewAramaFields.Language == "English");
filter.addfilter.AddWithAnd(ViewAramaFields.Language == "French");
On the ViewArama, there are both records about a man who knows Eng. and French. But This doesn't works. Is is because of they are on the different rows?
It would REALLY help if you could explain how your view looks like.
Your filter suggests that it will match with rows which have language set to English AND French, which IMHO means 0 rows will pop up.
So also what is the query generated ? (see troubleshooting/debugging -> tracing)
2th problem is, if i give just one filter to fetch like :
filter.addfilter.AddWithAnd(ViewAramaFields.Language == "English");
then there are some records. But these records are not distinct. There are repeated records. Pls show a way for these problems soon..
Could you specify 'false' for the allowDuplicates filter in the fetch /fill method you're calling when filling the typedview?
