Hi! DFD was brilliant on exporting from DQL etc, but in DFW this has been a big headache. 

Why is it that exporting with the Export Dialog is fast but DQL export etc is so slow?

Any tips on how this can be done faster?

Hi Andrew.

You are right. Exporting from DQL have been a nightmare. In 7.2 we fixed the DataExport() function so it could take the .dbe (predfined export definition) as a parameter but it is not without limitations. The problem with the DataExport function is that it use the GUI to do the exporting, so the fields/query need to be available to the function. 

You can call a Import (.dbi) from anywhere and it will import into the correct table, but a .dbe reference the current Multiview... Confusing? Yes!

We have completed a sample app which you will find on the blog.

http://www.dataease.com/DG3_BlogList/?ParentID=0000000112&field1=0000000112