>Does anyone have some insight into what may be the cause of this error?
>
>The help file says:
> View definition has been changed (Error 1494)
> The view cannot be re-queried.
>
>· The view definition in the database has been changed.
>
> Close and reopen the view. To ensure that the view is not
> changed, open the database exclusively.
>
>I am trying to requery a local view. The local view has not been changed. The local view is based on a remote view that has been changed. Where I am confused is that I have other forms doing the same thing and I cannot see any difference.
>
>
>Steve Smith
If you ever have a view based on a view, this kind of thing is possible. When VFP queries a view, it samples the data in the first few records to determine the width of the fields. If your base view was queried, and the columns widths came out to one number, and the seconds view (based on the first) was queried, then the fist requeried and the columns widths changed, the second would throw this error. Can you give the SQL that defines both views?
Erik Moore
Clientelligence