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
Title:
View definition has been changed ... not
Miscellaneous
Thread ID:
00759016
Message ID:
00759016
Views:
45
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,
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing
Next
Reply
Map
View

Click here to load this message in the networking platform