SQL filters with MAPITABLE

  • Thread starter Thread starter DENNIS BROWN
  • Start date Start date
D

DENNIS BROWN

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?
 
1. The "from" clause is ignored, but it needs to be there (just to make a SQL query). "Select whatever from Folder" should work.
2. Use AllDayEvent = 'true'

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
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?
 
Back
Top