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


DQL export using MemoExecDQL with 2 tables


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

DQL export using MemoExecDQL with 2 tables

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) 

Written by Marco Marchesi 27/06/16 at 08:04:12 Dataease [{8}]FIVE

Re:DQL export using MemoExecDQL with 2 tables

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*

Written by DataEase 29/06/16 at 18:17:28 Dataease [{8}]FIVE

Re:Re:DQL export using MemoExecDQL with 2 tables

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

Written by Marco Marchesi 06/07/16 at 14:08:15 Dataease [{8}]FIVE

Re:Re:Re:DQL export using MemoExecDQL with 2 tables

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.

Written by DataEase 06/07/16 at 19:37:56 Dataease [{8}]FIVE

Re:Re:Re:Re:DQL export using MemoExecDQL with 2 tables

Just to illustrate.

8.5 will also handle nested for sentences etc.

Written by DataEase 06/07/16 at 19:53:06 Dataease [{8}]FIVE