Devart Forums

Posted: **Mon 04 Sep 2006 10:03**

hi all..

im using MyDump in my codes in order to extract table script from my database. but i notice that i just can specify tables that we need using MyDump. How about if i wanna extract just several fields in my table. Currently i extract the whole fields in a table.

For your infomation..I have tried to use MyScript and MyBackup, but it doesnt work..may b i need your info..

can anybody help me.. thx frens..

Posted: **Mon 04 Sep 2006 13:22**

If you want to extract data from some columns of table you can use BackupSQL method. For example:

Code: Select all

  MyDump.BackupQuery('SELECT EName FROM emp');

will compose following insert statement:

Code: Select all

  INSERT INTO emp(EName) VALUES
    ('SMITH1'),
    ('ALLEN'),
    ...

Generating CREATE TABLE statement for some columns of the table is not supported.

> For your infomation..I have tried to use MyScript and MyBackup,
> but it doesnt work..may b i need your info..
If you find any bugs in MyDAC you can describe them on this forum or contact us by e-mail (evgeniyD*crlab*com).
The best way to report us about bugs is to send us a complete small sample to demonstrate the problem, including script to create and fill table.
Also following information is required
- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in Info sheet of TMyConnection Editor

Posted: **Tue 05 Sep 2006 02:49**

thx alots..its work..if i need ur info ill let u know..thx again!!

Devart Forums

MyDump..MyScript..MyBackup

MyDump..MyScript..MyBackup

its work :)