Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Definition has Changed.
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00694386
Message ID:
00694415
Views:
10
>I am getting this error and cannot get rid of it. I have deleted the local view and the bizobj recreated them giving the bizobj a new name and I still get this error. Is the framework storing this info somewhere that I need to clear out?
>
>
>Help,,,,Help,,,,Help
>
>Thanks

Your view must match the underlying structure of the table(s) you are querying. Doing things like have an IIF embedded in the view that can return a field that is a different length than the underlying table is one main cause. For example, if you have a NVL(field, "", field) AS field in your SQL, and the first record is a NULL, VFP will generate a cursor who's "field" is one character long instead of X characters it normally would create. You need to make sure you PADR the fields to the correct length in these cases. (hopefully that all makes sense...)
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform