Hi, I'm having trouble with TMSConnection and FetchAll=false. I already know, that there's problem with starting transaction with unfetched rows, so I simply want do fetch all already unfetched datasets. Ho can I do it? Can't find any such method, thus I'm using following now:
Code: Select all
for i := 0 to connection.DataSetCount - 1 do begin
if connection.DataSets[i] is TCustomMSDataset then begin
ds := connection.DataSets[i] as TCustomMSDataset;
if not ds.FetchAll then begin
ds.FetchAll := true;
ds.FetchAll := false;
end;
end;
end;
I simple HAVE TO start the transaction, what is the best solution? My solution works, but I don't like it at all