Easy to Create, Easy to Change - Easy to use!


What about Exporting from DQL etc?


Started by Andrew Enfield
Search
You will need to Sign In to be able to add or comment on the forum!

What about Exporting from DQL etc?

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?

Written by Andrew Enfield 25/07/13 at 18:19:05 Dataease [{8}]FIVE

Re:What about Exporting from DQL etc?

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

Written by DataEase 25/07/13 at 18:22:04 Dataease [{8}]FIVE