Thanks,
T try to use TSQLDataDriverEh but no result.
When execute TMemTableEh.RefreshRecord with TDataSetDriverEh the TMemTableEh reload all records.
Currently, I use the code below, but I'm looking for another better solution than this one.
Code:
CurrentId:=MemTableEh.FieldByName('ID').Value;
FDQuery.Refresh;
FDQuery.Locate('ID', CurrentId, []);
for i := 0 to MemTableEh.Rec.DataStruct.Count-1 do
begin
DataSetDriverEh.AssignFieldValue(MemTableEh.Rec.DataStruct.MemTableData, MemTableEh.Rec, i,
dvvRefreshValue, FDQuery) ;
end;
DBGridEh.Invalidate;