Are you sure of this?
I've had that problem before and all it did was truncate the data to the length of the field in the first record. I've never had it cause an error.




>This is usually caused by an IIF in the field list that could return a different length. Make sure you are using PADR (for example) to make sure all the fields in the result set are the same length. The view gets it's definition from the first record in the result set and if any other result has a different length you will get this error.
>
>HTH
>
>Dan
>
>>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