>No, I'm not using any function, but my the sql statement that I use to create the view contains a 'union'. Could this be the problem ?

It could be that some of the data in the parts of the union are converted into different lengths (this holds for both numeric and string fields). Now when you requery a view and the lengths of the fields in the first record are not the same as they were before the requery, Fox will report that the structure has changed. The change may come from either part of the query, which makes this more difficult to fix.

In local views, we can fix that using field+000000000.00 or padr() function; in remote views you'd have to use cast() into numeric(n,m) and char(n) to make sure the fields are the same width each time.

To find which fields exactly give you the problem, open the view several times using different parameters from the command window, and display structure after each USE. Find which fields change length.