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 ?
Partial dump
Re: Partial dump
Now we are considering enhancement of TMyDump functionality in this way.
We intend to add an additional method
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.
We intend to add an additional method
Code: Select all
procedure Backup(const Query: string); overload;
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.