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:
00160805
Vues:
22
>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.

Tom,

Another suggestion. Do you have calculated fields in your view? Strings with ALLTRIM() or numeric fields? For strings, I advise to remove all the TRIMS(). Since VFP will build the view with the first record it finds you cannot predict the length of your field. Or use PADR() to add the appropriate spaces. For calculated numeric fields, you'll probably have to use a UNION, something like this: SELECT 0000.00 AS nCalcField UNION .... or live the calculated field empty and fill after.

To check exactly what happens run GENDBC or GENBCX against your DBC. Open the generated program and check the view definition. Now run your form, and do a DISP STRU when you get your error 1494. Should be easy to resolve.

José
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform