custom views

[Joel Allen]

Hello,

For a while now, my custom views in Outlook keep getting corrupted. When I
have a view using a SQL filter, the single quotes ' will get replaced with
' thus causing the filter not to work properly. It will work for about
a week, then suddenly the view will get corrupted and I haven't even done
anything.

example:

this:

"http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/ProjectMngr"
= 'Joel'

becomes this:

"http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/ProjectMngr"
= 'Joel'

Anybody have any ideas why this strangeness is occurring?

Thanks for your help.
Joel

 

[Sue Mosher [MVP-Outlook]]

Where are you looking at the SQL filter? In what version of Outlook?

 

[Joel Allen]

Outlook 2003 SP2. I'm in the Filter of the Custom View Organzier.

I made a picture for you:
http://s217.photobucket.com/albums/...otobucket/Sue/?action=view&current=filter.jpg

Thanks,
Joel

Where are you looking at the SQL filter? In what version of Outlook?

 

[Sue Mosher [MVP-Outlook]]

Interesting. Haven't heard of a case like that before. I wonder if it has something to do with the complexity of your query. A good experiment would be to try a query with fewer terms and see if it's more stable.

Also, are you editing the filter through the Define Views dialog? If not, try doing that rather than editing it through the Current View menu.

 

[Elad]

hi
I have the same problem in my Outlook .
I'm working with win XP SP2 and Outlook 2003 SP2 (Exchange 2003)
I'm using the advanced filter to view tasks with due date "on or before"
"Today"
the filter goes automaticly to the SQL, then after a while it changed itself
from 'Today' to 'Today'

thanks to your help
Elad