Server calculated field - refresh on ApplyUpdates

Data Abstract
1

Hi all,

Server:

DataTable A:
Fields: F1, F2, F3 (complex calculation on trigger)

Client:

MemDataTable A:
Fields: F1, F2, F3

On OnFieldChange of F1 or F2 we perform Post and ApplyUpdates (using ReducedDelta), but field F3 does not refreshes. If we refresh MemDataTable, field F3 does reflect updates, but idea is to update F3 while user modifies other fields in record.
How to achieve this?

We have placed Post on OnAfterFieldChange event and ApplyUpdates on AfterPost event in order to achieve desired UI behavior, but F3 does not reflects trigger calculated value from server.

Kind regards,
Ivo Loncar

PS: We could not find any info about “ruoOnPost” property of TDAMemDataTable. Any detailed info about this option?

2

Hi.

For F3 field need to set “ServerAutoRefresh = true”, this means that fiels can be changed by DB server. Also in your table have to be defined primary key.

“ruoOnPost” means that after post ApplyUpdates will be called automatically.