Hello, I’ve got a problem with the Calendar control filters.

This is a very simple example, applied to the code that comes with the control (Against  SQLServer).

I have three events in the “CalendarEvents” table:

1                             Recurrence                      1                                            1

2                             Event number 1               3                                            1

3                             Event number 2               0                                            0

As you can see, I have a recurrence, an exception in that recurrence, and a free event. If I modify the “MakeRetrieveDayEventsSQL” function in the “SQLDataHelper” class, and then add the following line:

strSQL=strSQL + “ And subject like ‘%Event%’”

The calendar draws itself with the number 3 event ( Event number 2), but  the number 2 event (Event number 1) doesn’t appear.

I think that its caused because the filter is not loading the master recurrence, so is not executing the code “DoReadRPattern” from “m_pCalendar” that is also calling the function.

My question is: “Because I don’t  receive the recurrence in the SQL and the exceptions are never thrown, so the control never draws itself,  how should I apply the filters to avoid this limitation of the control?