TMyDump BUG

eduardosic · Post by **eduardosic** » Mon 26 Mar 2012 18:01

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.

AndreyZ · Post by **AndreyZ** » Tue 27 Mar 2012 08:58

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.

eduardosic · Post by **eduardosic** » Wed 11 Apr 2012 00:49

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

AndreyZ · Post by **AndreyZ** » Wed 11 Apr 2012 09:42

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.

eduardosic · Post by **eduardosic** » Wed 11 Apr 2012 11:36

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 () ?

AndreyZ · Post by **AndreyZ** » Wed 11 Apr 2012 12:00

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.