Problem with the Calendar Control filters

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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:

EventID               Subject                                RecurrenceState             RecurrencePatternID
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? 

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ecl2009 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 14 July 2009 Location: Spain Status: Offline Points: 1	Post Options Post Reply Quote ecl2009 Report Post Thanks(0) Quote Reply Topic: Problem with the Calendar Control filters Posted: 14 July 2009 at 7:20am
	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: EventID Subject RecurrenceState RecurrencePatternID 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?