I'm using Redemption to create a session, then I get the current folder, then I create a oCurrentItem by mapping it to my oCurrentFolder.Items.
I can get oCurrentItem.Count to return 27, the number of items in that folder, but what I want to do is use SQL to find all the items that have the AllDayEvent flag set, and, in another area of my code, find all the appointments that have a Start Some_Date AND Start Some_Other_Date.

I declare a oRecordSet object, then map it to the
oCurrentItem.MAPITABLE.ExecSQL("Select Subject From !Don't_Know_What_Goes_Here! Where AllDayEvent 1)
1. What goes in the "From" part of the string, and
2. Is the AllDayEvent 1 correct?
--

Thanks,
Dennis