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:
00588316
Views:
41
>>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...
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform