Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View definition has been changed ... not
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00759015
Message ID:
00759019
Views:
23
If you have character expressions in your view, use PADR() to make sure that size of the filed doesn't change depending on data retrieved.

>Sorry, couldn't find this in FAQ, but surely it's been asked and answered many times.
>
>I made a complicated parameterized view (in prg code) with left joins and NVL()s in the field list, set updateable=.T. and PK field updateable=.T..
>
>If I USE it NODATA, then immediately set the parameter var and REQUERY() it, I get "View definition has been changed."
>
>I know I saw this a month or two ago and solved it, but I can't remember what the simple little problem was ... like a certain illegal phrase in the view definition ...
>
>Help?
>
>TIA,
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform