The attached DQL export data from 2 different dataease tables but if i use it as normal DQL procedure it works perfectly but if i try to use it via MemoExecDQL it doesn't works. Why? Thanks (DataEase version 8.2.0.1700) 

Hi Marco.

The DQL export feature in "traditional DFW DQL" was an addendum made in DFW 5.x simply because you didn't have native export in DFW DQL.

ExecDQL has native export and does not support the .export to as this is done directly in the function.

If you enter a file name in the output argument you will automatically get a DataEase flat export file with Column Names as first line and ~ as seperator.

You can use another Memo to format the export as well.

http://www.dataease.com/dg3_HelpView/?PageID=10340&field1=*MemoExecDQL*

Hi DataEase,

ExecDQL works fine even if I use  .export directly in the function. It doesn't work only if I have two different table as originally requested.

using  MemoExecDQL(DQL,"","","","","")

I tried to use MemoExecDQL as follow: 

MemoExecDQL(DQL,"","","","","file:C:\test.txt")

and without using export inside the DQL, but the file exported doesn't report CR/LF at the end of the record as expected.

For details please open the word file attached.

Version 8.2.0.1700

We are really sorry but this version of DataEase 8 is too old.
The last version of 8.2 was released close on 2 years ago and all the issues you have are resolved in 8.5

.export is a deprecated feature and will not be fixed or amended in any way.

Exporting via ExecDQL has been widely enhanced in 8.5 and you can now export in any format you like by using an DQL body.

Any bug/fix will need to be indicated in the last release version of the product to be scheduled for repair and any fix would obviously only be available in future release of the product.

Just to illustrate.

8.5 will also handle nested for sentences etc.