crBatchMove and RecordCount

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ioda
Posts: 12
Joined: Fri 08 Feb 2008 15:11

crBatchMove and RecordCount

Post by ioda » Tue 22 Jun 2010 13:25

Hi,

I have a TMyQuery open with 20000 rows and I want to copy 500 first rows on the TVirtualTable with crBatchMove component. If I don't initialize RecordCount property, all rows are copied on the dataset, but if I initialize RecordCount to 500, zero row are copied in the dataset. I need to initialize other property to work ?

This is an exemple of my code

if dsetDetail.Active then
dsetDetail.EmptyTable;
dsetDetail.DisableControls;
qryDetail.First;
bthDetail.Source := qryDetail;
bthDetail.Destination := dsetDetail;
bthDetail.RecordCount := 500;
bthDetail.Execute;
dsetDetail.EnableControls;

ShowMessage('MovedCount : ' + IntToStr(bthDetail.MovedCount) + #13#10 +
'ProblemCount : ' + IntToStr(bthDetail.ProblemCount));

Thank you

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 23 Jun 2010 08:49

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

Post Reply