Hi,
try to clear table’s fields before second call like
lRemoteDataAdapter.FillWithDASql(lTable,DASQL1,nil);
...
lTable.Fields.Clear;
lRemoteDataAdapter.FillWithDASql(lTable,DASQL2,nil);
You have asked to store table’s fields at Calculate field doesn’t work for FillWithDASql
requests
as a result, 2nd call uses table’s fields from 1st call.