Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot requery view, urgent! error 1494
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00666719
Message ID:
00667892
Vues:
16
Hi Jaime,

I had this problem once,
-If it's a view including field of an another view, make sure to load in the dataenvironment the other view before the actual view.
-Make sure to not use "as select *" in the definition of your view, because when you add a field to a table, all the view related to this file will have to be regenerate.

Hope it help,
Eric.

>Hi all
>I created a parameterized view with 4 parameters. If i USE the view, it will ask me for the values, then a browse works with no problem, but since i have to requery it in my form, i do the following:
>USE MyView nodata
>vparam1="some value"
>... etc ...
>requery('MyView')
>
>There, i always get error number 1494: View Definition has been changed.
>I also tried to run this from the command window, and even entering the parameters by hand after i run the requery, but there's nothing to do.
>Using it normally will work though, so i'm getting quite frustrated...
>
>TIA
>Jaime
Eric.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform