Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why can't I update the view, again?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00182660
Message ID:
00182751
Views:
9
The first thing you need to do is find out why TALBEUPDATE() returned .F. Take a look at AERROR() and use it to find out what error is being returned when the update fails.

>Most of my forms use local param views to access and manipulate the data. Once in awhile, I have problems updating a view that is:
>1. Marked all fields as updatable.
>2. Send SQL Update checked.
>3. Issuing TABLEUPDATE(.T.,"vName") returns .F.
>
>I'm just simply trying to add a new record (e.g. APPEND BLANK). GETFLDSTATE() (form is set to Private DS and Optimistic BM) is returning appropriate status (either 3 or 4 for each field). I have almost identical view on the same form that works w/o ANY problem. I have tried:
>
>1. Recreating the view.
>2. Resetting the updatable settings.
>
>I had a similar problem with views before and in that case, it simply started working correctly after 2-3 days. Very strange.
Previous
Reply
Map
View

Click here to load this message in the networking platform