Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP 5. Error 1494 - View definition has been changed
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00159516
Message ID:
00159616
Vues:
28
Tom -

Does your view contain a left join with a table that may produce null's in the result set? I seem to recall getting this message if the first record in the result set contains a null--foxpro them makes the field width one. If the first record on a previous requery didn't have a null, then the field width will be different.

If the lookup field is 30 characters, try using nvl({field}, space(30)) in the list of fields. Note that you can't use space(len({field})); i forget why, but i think that foxpro will evaluate the length fo the field in the result set--so you're back to the first problem. hth.

- Mark

>Hi! all
>I have built a form to gather user parameters prior to printing a report. The view for the rpeort data is set to NoData On Load in the forms dataenviornment, and the view does not allow updates. When requering the view I get error 1494 - View definition has changed!
>Does any one no why this is happening?
>
>Thanks Tom.
----------
Mark Bucciarelli
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform