Partial dump

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mvalent
Posts: 62
Joined: Thu 04 Nov 2004 17:42

Partial dump

Post by mvalent » Wed 17 Nov 2004 09:56

Is it possible to create a "partial" dump ?
I like the TMyDump component but I wish I could get only some records from the table.
Is there a way to dump from a query ? Any suggestion ?

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

Re: Partial dump

Post by Ikar » Fri 19 Nov 2004 07:34

Now we are considering enhancement of TMyDump functionality in this way.
We intend to add an additional method

Code: Select all

procedure Backup(const Query: string); overload;
where Query - text of SELECT statement.

A result of this method call will be similar to a result of ordinary Backup execution except:
- if TableNames property isn't set, INSERT will be generated for the first table from Query
- if TableNames property includes the only table, INSERT will be created for this table
- if TableNames property has more than single table - error.

mvalent
Posts: 62
Joined: Thu 04 Nov 2004 17:42

Post by mvalent » Fri 19 Nov 2004 08:13

That would be just great ! :D

Post Reply