Since our migration to RO 10.0.0.1597 our code is broken
It appears for one table a (primary key) field does not get included in the insert statement.
The pat_primkey field is not included in the insert statement.
The TDABusinessProcessor.CreateMappings does not add the field because aCommand.Params does not contain the field
aCommand.Params.Count=7
while lDeltaFieldList.Count=10
Note: We are using reduceddelta=true (via a modified udabusinessprocessor.pas)
can you retest this issue with original uDABusinessProcessor.pas, pls ? ReducedMode should be set on client-side in Bin2DataStreamer and changing it on server-side may cause some problems.
I guess we can put DataStreamer.SendReducedDelta:=True; in the constructor of all our classes that derive from TDAMemDataTable. Any idea why we didn’t take this approach in 2010?
We define multiple statements that we then use via the connection name. This allows us to use (highly) different selects with the same DA interface file.
I can suggest to review code of TDASchema.FindCommandStatement method.
Probably you can find valid condition that will work for you. Also we can make this method virtual so you can override default logic in your TDASchema’s descendant. will it work for you?