I'm simplifying this untill someone asks for details.
I have a parametized view that I've been using for 1 1/2 years with no problem. All of a sudden I'm getting "view definition has changed" SOMETIMES when I try to open it.
One of the parameters is "cs_Date>=?pdBegin and cs_Date<=?pdEnd".
I've discoverd these results:
pdBegin pdEnd Results
Single Date Range
{4/3/2} {4/3/2} Opens
{4/4/2} {4/4/2} Error
{4/5/2} {4/5/2} Error
{4/6/2} {4/6/2} Error
{4/7/2} {4/7/2} Opens
Multi Date Range
{4/4/2} {4/10/2} Opens
{4/4/2} {4/5/2} Opens
{4/5/2} {4/6/2} Opens
I've tried reindexing the table.
I orginally guessed that I had corrupted data, but couldn't see it. But no other form or report or browse has a problem with the data. I haven't started trying to track down a particular record that might be causing this, but after those last two results, I'm wondering if it's even worth trying.
TIA
Bill Morris