Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field in a view is not updated!!!
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00588249
Message ID:
00588604
Views:
43
This message has been marked as a message which has helped to the initial question of the thread.
Would doing a DoDefault() before your code solve the problem. I seem to remember something along those lines (sorry - I don't have time to check) I also have a memory of then having to do a nodefault so that it doesn't fire twice - but as you are checking for a change a second fire probable doesn't matter.


>>>I checked this view in the command window, Memo field updates correctly. However, in my application it doesn't work in some cases:(
>>
>>Umm. So it appears the problem is not with the view. Any strange goings on with the control you use to edit the field? Maybe the controlsource is getting chnaged or something.
>
>Hi Roi,
>
>I think, the problem is in "incorrect" sequence of events firing. In Grid.textbox for memo I have in LostFocus
>if this.OldValue<>this.value or getfldstate("Notes","FilingView")<>1
>   =tableupdate(0,.t.,"FilingView")
>endif
>
>However, it seems like this event is firing before my changes. E.g. I change my Memo to "Nadya", go to another record in the upper grid, then back (each time I have tableupdate and requery()) and see the previous content of the memo. I change it to "Tanya", repeat these procedures, and see "Nadya" in Memo. E.g. it's always one "step" back. I think, I'll remove LostFocus event and put TableUpdate in Grid.AfterRowConChange and Valid methods instead. Hopefully, it would solve this strange problem...
Caroline
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform