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:
00159616
Views:
27
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform