Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 1494/View definition has been changed
Message
De
15/07/1999 20:05:58
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00241933
Message ID:
00242085
Vues:
28
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform