Hi Dany,

I regularly use views and PG in situations like the one you describe and I don't have that problem.

I simply don't trust the view designer and always hand-code my views. I would suggest that you hand-code this particular view and see if that solves the problem.

Can you post the SQL that the view designer has generated for creating the view?

Regards,

Liam



>Hi Liam,
>
>first of all, thanks for your time !
>
>Yes, I use the View Designer. I had no problem with that so far.
>
>Let me try to explain the case:
>
>The table (SQL) has several fields, some of them are numeric type with 2 digit precision. If the view has no calculated columns everything works fine. But if there is a column like FieldX-FieldY and the programm calls the REQUERY() functions I get an error message (view definition has benn changed), just like VFP detected a difference between the data type or length of that column has been changed !
>
>Remember that this problems occurs only in case of calculated columns, woth filter clause, after a REQUERY().
>
>Regards,
>
>Dany