Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo Field in a Grid - refuses to update
Message
From
04/12/2001 02:01:03
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00588744
Message ID:
00589089
Views:
30
>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.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform