Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 5. Error 1494 - View definition has been changed
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00159516
Message ID:
00160805
Views:
20
>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é
Previous
Reply
Map
View

Click here to load this message in the networking platform