Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View definition has been changed error
Message
From
23/07/2002 15:17:43
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00681724
Message ID:
00681828
Views:
14
>I have a standard business object that has one local view in its data environment. The view has two parameter fields and is based on three tables. When I instantiate the object, enter the parameters and execute the "Requery" method, I get the "View Definition has been changed" error. However, if I browse the local view and enter the same parameters the view successfully accesses the proper data.

I think the error code (1494, if I remember correctly) is also something to search for - I remember I had a thread like that a couple of months ago.

Another reason for the error may be the use of nvl() function - if the lengths of the values it returns may be different for any reason. I know how this bit me - I used nvl(field, 0000) on a three-digit field. The view was open with NoDataOnLoad (in VFE, but I think MM doesn't differ here), so its structure was decided by the null case, and this field came in as n(4). On the next requery, it would be n(3), because it got the real field now.

Basically, anything that can return values of varying length should be tamed into a fixed length. In my case, it should have been nvl(field,0)+000. Any string should be pad()ed to desired length.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform