TBatchMove

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
charliejo
Posts: 11
Joined: Mon 02 Jan 2006 12:53

TBatchMove

Post by charliejo » Mon 02 Jan 2006 12:54

Hello,
I can't use TBatchMove with TMyTable.... what is the solution?

Thanks

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 03 Jan 2006 12:51

Currently MyDAC doesn't support TBatchMove. We have in plans to add this feature, but we can't specify a date. Now you should copy values manually.

charliejo
Posts: 11
Joined: Mon 02 Jan 2006 12:53

Post by charliejo » Tue 03 Jan 2006 18:07

I found the solution with TMyQuery and a request SQL : "INSERT INTO TABLE1 (Field1,Field2...) SELECT * FROM TABLE2"
And fonction Execute()

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Wed 04 Jan 2006 14:37

This is best way to copy data, if you copy data within one server.

Post Reply