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
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao