>All
>
>I have a complicated view I create in code. When I requery this view I get:
>
>View definition has been changed.
>
This is almost always caused by an ALLTRIM() in the view definition, or a call to some other function that can cause the results to contain fields of variable length. What happens is the that first call defines the structure of the view cursor with the results. If subsequent calls return data that is ALLTRIM()ed (or whatever) to a different length, you get this error.
Another common reason for this is a view based on a view, but I don't think this applies to you...
Erik Moore
Clientelligence