Page 1 of 1

TMyDump BUG

Posted: Mon 26 Mar 2012 18:01
by eduardosic
Hi, myDac version is 7.1.4 - Delphi 2007 Pro

In designe time, two click in TmyDump and click in Backup button
raise IDE exception: Error reading DADumpProgressForm.OnResize: Invalid property value.

the procedure MyDump.BackupToFile
don't create a backup from Join Tables, only first table have backup data.

if you made some diferents SQL in BackupToFile
the result is wrong.

Posted: Tue 27 Mar 2012 08:58
by AndreyZ
Hello,

The "Invalid property value" error is fixed in MyDAC 7.1.5 .
Please specify what you mean by "backup from Join Tables". TMyDump dumps tables and views that are specified in the TableNames property, or all tables and views if TableNames is blank. Please give us more detailed description of the problem with the BackupToFile method.

Posted: Wed 11 Apr 2012 00:49
by eduardosic
AndreyZ wrote:Hello,

The "Invalid property value" error is fixed in MyDAC 7.1.5 .
Please specify what you mean by "backup from Join Tables". TMyDump dumps tables and views that are specified in the TableNames property, or all tables and views if TableNames is blank. Please give us more detailed description of the problem with the BackupToFile method.
If you try
MyDump.BackupQuery( 'Select A.Cod, A.Name, B.Value from Custumer A
inner join money B on A.ID = B.ID' );

The result backup contain only Table custumer data and Fields

Posted: Wed 11 Apr 2012 09:42
by AndreyZ
The point is that if a query selects data from several tables, only data of the first table in the from list will be dumped. You can find this information in the description of the BackupQuery method in the MyDAC documentation.

Posted: Wed 11 Apr 2012 11:36
by eduardosic
AndreyZ wrote:The point is that if a query selects data from several tables, only data of the first table in the from list will be dumped. You can find this information in the description of the BackupQuery method in the MyDAC documentation.
ok, would be an excellent resource to be done dump the result set, regardless of the tables involved.
How about a new method: BackupResult () ?

Posted: Wed 11 Apr 2012 12:00
by AndreyZ
You can leave your suggestion at our UserVoice page at http://devart.uservoice.com/forums/1046 ... components , and if there are many votes for your suggestion, we will implement it.