Partial dump

Partial dump

Postby 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 ?
Posts: 62
Joined: Thu 04 Nov 2004 17:42

Re: Partial dump

Postby 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.
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby mvalent » Fri 19 Nov 2004 08:13

That would be just great ! :D
Posts: 62
Joined: Thu 04 Nov 2004 17:42

Return to MySQL Data Access Components