TDALocalDataAdapter Apply SendReducedDelta

Data Abstract
1

Hi,

If i m using TDALocalDataAdapter at server side service module , how can I apply the SendReducedDelta effect like DARemoteDataAdapter with DABin2DataStreamer？

Please advise

joe

2

Hi,

The SendReducedDelta mode is used only for reducing network traffic.
TDALocalDataAdapter works only in two-tier applications so we haven’t need to reduce network traffic. as a result, all delta values are passed

3

Thanks,

Then how to contruct the update statement only based on the changed field?

I need use businessProcessor to achieve it?

Joe

4

Hi,

TDABusinessProcessor requires delta in the ReducedDelta mode for generating such SQLs.

We disallow changing this mode, but you can review trick in TDADataTable.ResetReducedDeltaState method

5

May be something misleading.

if i need update the changed field ( only delta field), how can I achieve this case.

For example:

TDAmemDatatable with DARemoteDataAdapter and DABin2DataStreamer.

I already setup the primary key field.

If I edit one record and only change one field only, how’s update being generated?

like
update TARGET_TBL
SET FIELD = NEW_FIELD_VALUE WHERE PRIMARY_KEY_FIELD = 1;

or it will generated the update statement to update all field ?

As I need achieve is only update the changed field only like only update delta.

Please advise

6

Hi,

Default behavior: generation of universal delta commands (Insert/Update/Delete) for all possible cases, i.e. with all fields.

7

Any Example if I need generate the update command only to the changed mean only ?

8

Hi,

You can use RDA and Bin2 streamer via TROLocalChannel/TROLocalServer

9

Thanks, I check the case first.