http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 14 Aug 2026 00:36:34 +0000 Sun, 03 May 2009 17:34:35 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=14205 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=14205&PID=48579&title=doreadrpattern-timeout#48579 Author: mhuratdo
Subject: 14205
Posted: 03 May 2009 at 5:34pm

I'm using the Activex Version of the calendar control with a custom data provider.

I can generate recurrence patterns (apparently ok) but when I try to read them I get a timeout. The problem seems to be because I'm reading the whole month and the DoRetrieveDayEvents is re-reading all the events every time.

This happens because the MakeRetrieveDayEventsSQL sql string retrieves all the events before the day been read (as in the C# example)

This should be ok, because I have to read the former events to be able to check if there is recurrence. I coded my program just like the C# example, but I get this timeout constantly.

In the other hand it doesn't seem to be a method for finding an event in the calendar (so i don't create the same event every time).

Any ideas? what should I do? change the SQL String or checking if the event exists?

This is the SQL string generated for today

SELECT * FROM dbo.Events WHERE (RecurrenceState = 0 OR RecurrenceState = 1) AND
(YEAR(dtFrom) < 2009   OR (YEAR(dtFrom) = 2009 AND (MONTH(dtFrom) < 5 OR MONTH(dtFrom) = 5 AND DAY(dtFrom) <= 3   ))) AND (YEAR(dtTo) > 2009 OR (YEAR(dtTo) = 2009 AND (MONTH(dtTo) > 5 OR   MONTH(dtTo) = 5 AND DAY(dtTo) >= 3 )))


Any ideas?]]> Sun, 03 May 2009 17:34:35 +0000 http://forum.codejock.com/forum_posts.asp?TID=14205&PID=48579&title=doreadrpattern-timeout#48579