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

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

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Joel Allen" wrote in message ...
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

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

I made a picture for you:
http://s217.photobucket.com/albums/c...ent=filter.jpg

Thanks,
Joel

"Sue Mosher [MVP-Outlook]" wrote in message
...
Where are you looking at the SQL filter? In what version of Outlook?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Joel Allen" wrote in message
...
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

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.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Joel Allen" wrote in message ...
Outlook 2003 SP2. I'm in the Filter of the Custom View Organzier.

I made a picture for you:
http://s217.photobucket.com/albums/c...ent=filter.jpg

Thanks,
Joel

"Sue Mosher [MVP-Outlook]" wrote in message
...
Where are you looking at the SQL filter? In what version of Outlook?

"Joel Allen" wrote in message
...
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?

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

"Sue Mosher [MVP-Outlook]" wrote:

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.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Joel Allen" wrote in message ...
Outlook 2003 SP2. I'm in the Filter of the Custom View Organzier.

I made a picture for you:
http://s217.photobucket.com/albums/c...ent=filter.jpg

Thanks,
Joel

"Sue Mosher [MVP-Outlook]" wrote in message
...
Where are you looking at the SQL filter? In what version of Outlook?

"Joel Allen" wrote in message
...
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?