Devart Forums

Hello all,

I searched forum but i haven't find any solution yet.

Case : I have two tables and i want to dump like this :

//First table proc.. table1
mydump.connection := conn1;
mydump.BackupQuery('etc...from table1);
mydump.connection := conn2;
mydump.Restore

//Clear all
mydump.Sql.clear;

//Second table proc. table2
mydump.connection := conn1;
mydump.BackupQuery('etc...from table2);
mydump.connection := conn2;
mydump.Restore;

Problem is the first one getting right sql script like "insert into table1" etc.. with correct data(table1 data), but second one getting same "insert into table1 etc.." statements with correct data ( table2 data). ??

How can i reset MyDump object after first use? I tried everything bu i cant reset MyDump cache or whatelse...

Thanks,

I found solution writing same BackupQuery double times, so stupidly but no way i mean...

myDump.BackupQuery('select ...from table2');
//And again
myDump.BackupQuery('select ...from table2);
...
etc.

It is good to see that this problem has been solved.