I'm seeing a problem with removing appended records in a grid. While sitting on the appended record, in the AfterRowColChange method I do the following:
lnRecNo = the record that was active before APPEND
*-- At this point the following is true:
*-- this.ActiveRow = RECCOUNT() + 1
*-- RECNO() = -1
=TABLEREVERT(.T., "ReqView")
*-- At this point the following is true:
*-- this.ActiveRow = 0
*-- RECNO() = RECCOUNT() + 1
GO (lnRecNo) IN ReqView
*-- At this point the following is true:
*-- this.ActiveRow = 0
*-- RECNO() = lnRecNo
this.Refresh()
*-- At this point the following is true:
*-- this.ActiveRow = 0
*-- RECNO() = RECCOOUNT() + 1
If I put a WAIT WINDOW command in after the TABLEREVERT() everything works as expected:
*-- this.ActiveRow = lnRecNo
*-- RECNO() = lnRecNo
The cursor in the grid is a local view on two joined tables using optimistic table buffering. The view is set to "SendUpdates" to one of the tables, but not the other.
What's going on with the Refresh()?