View and a DBGrid - Records lost after Update

[so-photo]

Hi

I have a table in a DBGrid. If I now send Updated with calculations to the server and then do a refresh record I have the record of above or below standing in the place. Only deactivating and activating brings back the correct display.

Fetchall, CursorUpdate, DMLRefresh, FullRefresh, RemoveOnRefresh tested in all logical combinations brings me but no solution.

Someone already had something?

Delphi XE7, latest sdac 8.0.5, MS Server 14.

Thanks
Stevie

[Stellar]

If no index was set for TMSTable/TMSQuery, then after changing, the record in the client DataSet will remain in the same position. If, after changing the record, you will update the Dataset data, for example by calling the Refresh method, then the server can return data where the changed record may take a different position. Unfortunately, we cannot influence the server behavior, you can read more information about this behavior in MS SQL Server documentation.