Hi John,

In addition to what others have said, it is probably the variability of the length of one of the result fields. It most often happens to me when the view involves a left join with a child table. In those cases, my sql statement changes to : Select..... OOOOO.OO + NVL(childtable.amount,0) or something like that that will guarantee a consistent size of the result field.

Hope this helps,

Ken


>Hi,
>I have a view that cause error "view defination has been changed" while I REQUERY() in form. However, it works fine if I call REQUERY() from command window. Any ideas?
>
>Thank you