>I have a form with a pageframe on it.
>
>There is a Save button on the form outside the pagegrame.
>
>Page 3 contains a grid.
>
>The recordsource for the grid is a cursor created via an SQLEXEC from a MySql table. The cursor has Buffering set to 5 as well as Tables, UpdateNameList, UpdatableFieldList, KeyFieldList, and SendUpdate properties.
>
>One of the grid's columns contains an editbox. When I make changes to the edit box and click anywhere else in the grid all seems to be ok.
>
>However, if I make in change in the edit box and then click the form's save button, the changes do not seem to take place. In one version of my code the DynamicBackColor did not change. In the current version, the changes actually disappear.
>
>In the save button I do some data checks, make sure the correct cursor is selected, and then issue TABLEUPDATE(1,.T.).
>
>Could somebody point me in the right direction to get the last changes included when I click directly on the save button?
>
>All help appreciated...........Rich
It actually may have nothing to do with the grid. You need to do some trick such as this.value = this.value or call form's ActiveControl.Valid() method. We have a special method WriteBuffer to make sure the latest changes are saved as well.
If it's not broken, fix it until it is.
My Blog