Larry,

In this case, no UDFs

This is a view based on another view.
I just tried to open the view in the Database Designer and resaved it. The view then return incorrect information. When I recreate the view, I get the View definition has been changed message.

Any other ideas?

TIA

Rex

>This problem can occur if you call any functions in your view, open the view NODATA and then subsequently requery it to populate it. The view will build itself based on the first record in the table to determine structure.
>
>For example, if you have a function that takes the value of a field and returns some other value, the structure will initially be built using a blank value (datatype dependent). If the function returns different values based on the value passed in, this would cause the error.

>Ex.
>function myvalue(puValue)
>local luretval
>if puValue = 0 then
>   luretval = 0
>else
>   luretval = 100/puvalue
>endif
>return luretval

>If the value passed in is a numeric 5,2 then the output with real values will be 5,2. However, when opening the view initially the structure will be numeric 1. ERROR!
>
>HTH.
>
>>All
>>
>>I have a complicated view I create in code. When I requery this view I get:
>>
>>View definition has been changed.
>>
>>No problem, I drop the view and recreate the view, but to no avail.
>>
>>1) I know changing the base table structures will cause this message, but what
>> else can cause this?
>>
>>2) What is the solution?
>> I can restore my data, but when I run the app, the view corrupts again.
>>
>>TIA
>>
>>Rex