you can use any of these workarounds:
- the same as on client-side via table: TDAMemDataTable should be linked to TDALocalDataAdapter (LDA) in the same was as to TDARemoteDataAdapter (RDA). LDA should be linked to DataService. if you wants to put logic into the same DataService, you may link as
LDA.ServiceInstance := Self;.
After this use usual
- manually, via SQL.
it can be like
ic := Connection.NewCommand('insert .....', stSQL);
ic.RefreshParams; // if needed
ic.ParamByName('...').Value := ...; // if needed
we haven’t done this automatically, so timer solution will work
You can add some custom logic to server to store timestamp of last update from any client.
for example, this method service methods will return this info:
function LastUpdated: TDateTime;
if correspondent value differ on client-side, server has some updates.
by other side, you can store more info on server-side like new/changed/deleted PK and give to client additional info …