The User Guide does not mention how Calendar Form of Query Results are sorted. Sort order is also not an option on the screen where you define the Calendar query.
How are they sorted?
Thanks,
Tom
How are Calendar objects sorted?
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Thanks for your note. I can undertand why you thought that it "doesn't make sense to sort by anything else" for 'normal' calendar items.
What I failed to say was that I was working on my 2 uses of calendar functions that 100% use All Day Events. (see my post at http://www.awareim.com/forum/viewtopic.php?t=1428 ) With All Day Events, sorting by time really has no meaning. If you have a few different All Day Events on 1 day, they are sorting by SOMETHING.
If you look at Common Controls Scheduler Sample 901 (http://www.common-controls.com/cc2/sche ... heduler.do) you will notice that if you edit an All Day Event (http://www.common-controls.com/cc2/sche ... 2611838684), the Starts At and End At only have date info -- all times are 00:00:00 for All Day Events. Even though you might see Start and End times when you first create an Add Day Event, the Common Controls example replaces them with 00:00:00 times.
In my 2 Aware IM calendars that use 100% All Day Events, I am using a rule to set the All Day Event attribute to "yes" (and not displaying it on the Form). I am also entering the dates in mm/dd/yy formats (no times).
Through experimenting, I have found that multiple All Day Events on 1 day seem to sort by the order they were entered.
I don't have any remaining questions. I just thought I'd share my learnings with anyone that might be interested.
Tom
What I failed to say was that I was working on my 2 uses of calendar functions that 100% use All Day Events. (see my post at http://www.awareim.com/forum/viewtopic.php?t=1428 ) With All Day Events, sorting by time really has no meaning. If you have a few different All Day Events on 1 day, they are sorting by SOMETHING.
If you look at Common Controls Scheduler Sample 901 (http://www.common-controls.com/cc2/sche ... heduler.do) you will notice that if you edit an All Day Event (http://www.common-controls.com/cc2/sche ... 2611838684), the Starts At and End At only have date info -- all times are 00:00:00 for All Day Events. Even though you might see Start and End times when you first create an Add Day Event, the Common Controls example replaces them with 00:00:00 times.
In my 2 Aware IM calendars that use 100% All Day Events, I am using a rule to set the All Day Event attribute to "yes" (and not displaying it on the Form). I am also entering the dates in mm/dd/yy formats (no times).
Through experimenting, I have found that multiple All Day Events on 1 day seem to sort by the order they were entered.
I don't have any remaining questions. I just thought I'd share my learnings with anyone that might be interested.
Tom