Forcing a field to update for delta updates

[fvancrae (Frederic Vancraeyveldt)]

I am using a RO DataTable to view and edit a DB table

At the same time however I perform DB stored procedures which modify the some if the same fields.

I am now running into an issue that my ApplyUpdates does not update a particular field because I use DA delta changes which does not update because it does not know about the change.

This is what happens chronologically:

1. DataTable gets loaded in TDADataTable
2. Some stored procedure changes field ‘myfield’ from ‘origval’ to ‘newval’
3. In DA DataTable we perform other tasks and set ‘myfield’ to ‘origval’
4. We call DataTable.ApplyUpdates()

The SQL update statement will not contain ‘myfield’ because the DataTable believes it is not modified

I would like to set this ‘myfield’ to ‘dirty/modified’ manually.

Is this possible?

Can I just change the value twice? Is this a future proof solution?

[EvgenyK (Evgeny Karpov)]

Hi,

I can suggest:

• call table.RefreshRow before editing. it will actualize data with server-side.
• don’t use Reduced Delta feature
• use BusinessProcessor.UserUpdateFields for adding extra fields used at generation of update/delete sql.
  Note: you should have personal BP or update autogenerated BP via DataService event for setting UpdateMode & UserUpdateFields properties.

[fvancrae (Frederic Vancraeyveldt)]

OK, thanks,

These are all quite laboursome however.

After my post I found this issue in talk so I went with this approach

Force the update of a field in reduced delta mode

hi Evgeny, i’m using the code below to always make sure a field gets updated regardless of the fact if this field is changed or not, cause i want it to reflect the state in which the record exist when persisting procedure datable.forcestateforprimkey(const pk:integer) for I := 0 to Self.Delta.Count-1 do begin if Self.Delta.Changes[I].ChangeType = ctUpdate then begin if (Self.Delta.Changes[I].OldValueByName[fld__primkey] = pk) AND (Self.Delta.Changes[I].OldValueByName…

I assume this is also future proof