Do you have any data for the dates that generate error? Can you post View's SQL?
>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
--sb--