>Hi everybody,
>
>Sorry for starting another thread, but I'm in desperate. I have a local view based on one table. Table is called FilingDate, view is called FilingView. It has one memo field called Notes. I have two grids in my form:
>upper grid is BatchCntrl, the other one (related) is FilingView grid. Here is a code in BatchCntrl.AfterRowColChange:
>
>lparameters ncolindex
[snip snip]
>endif
>dodefault(m.ncolindex)
>
>I also added TableUpdate in grdFiling.AfterRowColChange and grdFiling.Valid. There are other places, when TableUpdate is called as well. I don't see any error's reports. However, if I change something in the memo, then go to another record in the BatchCntrl grid, then go back to my original record, my changes are reverted back to the original. If I repeat this procedure, but change something again, I now see my previous change. Our form has its own Error Handler. However, errors are not reported, so I think, tableupdate worked fine.
1. failed tableupdate won't raise an error, it will just return .f.
2. looks like the problem with toolbars when the control's source is not updated until the control loses focus. Could you try to put another tableupdate() in the lostfocus of the editbox, and actually check whether it's firing at all?
3. If it won't, there'd be a way to instantiate a separate memo editing window from both .editbox.[dbl]click and .editbox.keypress, followed by a setfocus to the next control to the right of it when this window closes (i.e. it should be modal and have its own Replace MemoField with this.edit1.value), and then see if the editbox in the grid gets the new value of this external editbox.
>I use standard textbox in a grid for memo field. DoubleClick brings a window for editing...
>
>Could you please advise, what could be wrong here? Same view works from command window and update Memo field correctly.
Ahem, now I read this - I was looking at the code all the time and only now I saw this "window for editing"... what is it, a "modify memo" window? These windows may get automatically closed without saving, I remember VPM was doing it from its error handler (which was a real PITA, you try something in the command window, make a syntax error, and lose all the work in all open windows). Rather use a custom form with just an editbox, OK and Cancel buttons, and make sure it does a replace when clicked on OK. Just pass it the controlsource as a parameter.