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