What settings do I need to make a DBAdvGrid work “normally” for editing a dataset combined with a navigator?
I’m using it with a dbadvnavigator, simple text columns, and there are several issues when there are post/insert/cancel operations, especially when the cell editor is active.
I’ve tried many workarounds I found in the forum from years ago, and nothing gets better. Even with the Demos I have the same problems.
I work with PageMode, epRow, nonsequenced, RefreshOnInsert, RefreshOnDelete, AllowInsert/DeleteRows, AdvanceInsert=False, AdvanceOnEnter, adLeftRightInRow.
If I’m editing a cell and then press Cancel, the grid repositions to a valid row, but the cell content remains the same I was editing before. Sometimes it changes back to the real value when I click on something else that makes the grid refresh or repaint. Scrolling the grid also make it show the right values again. Calling grid.Refresh or grid.HideInplaceEditor in AfterCancel event has no positive effect.
If I’m editing a cell during an insert/modify operation , if I press , it Posts the previous Row, inserts a new one on the grid, and the editor remains with the previous value I was editing.
Are there other properties I should set to avoid this? Any dataset/navigator and/or grid Events I should use to avoid it?