Simplicty and flexibility!


Function::Internal

ExecDQL
ExecDQL("DQL Script","Data-Entry Field1","Data-Entry Field2","Data-Entry Field3","Data-Entry Field3","Export File")
ExecDQL("delete records in MyTable.")
ExecDQL("for My Table with MyField=Data-Entry Field1 ; modify records My Field2=data-entry field2 .",


To run a DQL script as a function from anywhere.

DQL is the most useful part of a DE application but it has had its limitations because it has been part of the DQL document (report). With ExecDQL we have liberated it, and you can now call a DQL from anywhere at anytime. It follow normal DQL syntax rules and it will generate an variable length export file if you include a file name as the last parameter (parameter 6).

Because it is a function you have to reference the Data-entry fields (transfered as parameter 2-5) with fixed names i.e Field1, Field2, Field3 and Field4. Other than that it is completely traditional DQL.

The ExecDQL has the GUI context of the document from where it is called, so you can read and manipulate the document from the DQL. This means that ExecDQL is not only a Data manipulating procedure it can also be a GUI manipulating procedure.

If you need more input variables than 4 you can simply pick them out of the Form you are calling the ExecDQL from with GetValue()

To make ExecDQL and other parts of DE8 more effective we have also introduced ESCAPE values in DE8 Strings.

Early in 8.0 we introduced CHR() to make it easier (possible) to use reserved letters in DE derivations and DQL etc. However it is a little awkward when you have to use ConCat() to joint things together for instance in a ExecDQL etc.

Ex. 
ExecDQL(concat("message ", chr(34), "Hello world!",chr(34)," window.","","","","","") 

So now you can simply do this with the escape charcter for ".
Ex.
ExecDQL("Message /'Hello World!/' window .") 

The observant reader also see that we don't add all the "" at the end of the function. This is news in 8.2 too. We have introduced variable number of parameters to make the functions more user friendly.

Up to now you had to be exact with your parameters and that could be a chore when the only thing you wanted was to execute a small line of commands with no export, and no input.

You will still have to follow the numbers so if you want to include an export file for ExecDQL you will need to include 4 empty "" as parameters before the export file name, but if you only need two data-entry parameters you can now simply add the two and skip the 3 last parameters.

LegEasy9 Onwards.

Support for ExecDQL system table. 
Default name: $$DQLStore$$
Default names in tables see below:

@name and #number. Also added support for settings under ini section [EXECDQL] in ini in DE and also prefix on server. Supported values are:

[EXECDQL]

DqlTableName= default $$DQLStore$$

DqlNameField= default DQLName

DqlIDField= default DQLId

DqlCodeField= default DQLScript

DqlBodyField= default DQLBody

Parameters


DQL: (String)

Here you can write a DQL script up to 255 characters long. It can do anything a DQL can do and has the same format as any other DQL

Data-Entry Field1: (String)

This is the parameter that you can reference inside the DQL script as Data-Entry field1.

Data-Entry Field2: (String)

This is the parameter that you can reference inside the DQL script as Data-Entry field2.

Data-Entry Field3: (String)

This is the parameter that you can reference inside the DQL script as Data-Entry field3.

Data-Entry Field4: (String)

This is the parameter that you can reference inside the DQL script as Data-Entry field4.

Export File: (String)

ExecDQL was designed to cover two major flaws in the DQL hierarchy of DFW. Manipulation and export so if you add a file name her and a list records in the DQL it will create a CSV file with column headers where the columns are in the order you put them in the list records.

PS! It is extremely quick.

Returns/Result


Nothing

Examples


Reference

See Also


CHR()

GetValue()
MemoExecDQL()
LabelExecDQL()
TextExecDQL()
StringEscape()

On the forum about ExecDQL

ExecDQL....

I have been downloading the a ExecDQL sample but I can't get it to work.What do I do wrong?...

Product: Dataease [{8}]FIVE. Written by John D. Alinson 09/05/13 at 11:46:47

Re:ExecDQL....

Too little information to give a guaranteed correct answer but I think we can give some general pointers ;-)ExecDQL is a completely new concept and might be a little hard to get around, but get used to it because you will see a lot more of thi...

Product: Dataease [{8}]FIVE. Written by DataEase 09/05/13 at 11:53:48

ExecDQL seems pretty good feature.

Question is, are we able to use this like a regular DQL ?...

Product: Dataease [{8}]FIVE. Written by Arul 25/07/13 at 08:35:43

Re:ExecDQL seems pretty good feature.

ExecDQL is the best thing since white bread. ExecDQL is just DQL but the point of it is that it isn’t regular DQL. ExecDQL is DQL as a function so it doesn’t create any output directly other than an export file if you want to. That op...

Product: Dataease [{8}]FIVE. Written by DataEase 25/07/13 at 08:36:12

Why Traditional DQL vs ExecDQL?

I know you would suggest that we use ExecDQL in DE8. But, I had a question to why we should use it. As it does not have any formula or validation check build-in. If I want to use ExecDQL, I have to always check the DQL in our old...

Product: Dataease [{8}]FIVE. Written by Arul 30/09/13 at 08:05:08

Re:Why Traditional DQL vs ExecDQL?

You need to change your understanding of DQL to have any use of ExecDQL. I think we need to start breaking down some walls/misconceptions here. 1. DQL is the query/transaction language of DataEase and not a reporting lang...

Product: Dataease [{8}]FIVE. Written by DataEase 30/09/13 at 10:14:20

DE8 - ExecDQL Sample App

I just want to ask about the sample app about ExecDQL here http:/...

Product: Dataease [{8}]FIVE. Written by Fatma 01/10/13 at 09:31:01

Re:DE8 - ExecDQL Sample App

You are not, it is “our bug” and it is almost left there to remind us of how important it is to not re-use names/replace functionality but add ;-) SetGlobal() is an old CDF unrelated to us. It was developed by someone else, but w...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 01/10/13 at 09:31:36

CSV files - Export To vs EXECDQL

I am using V8.1.1.1435 (Or V8.1.0.1435 as it says in Help/About DataEase).I am producing a CSV file using EXPORT TO in a DQL procedure and it produces it correctly (Albeit with a variable number of Carriage Return/Line Feed pairs at the end of...

Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 16/12/13 at 11:10:33

Re:CSV files - Export To vs EXECDQL

Hi Pete.No need to use Export to in ExecDQL anyway.As we all know the Export To functionality that was "panic" implemented back when DFW 5 was released as never been what it should be nor anything close to what it was supposed to repla...

Product: Dataease [{8}]FIVE. Written by DataEase 17/12/13 at 11:04:46

Re:Re:CSV files - Export To vs EXECDQL

Hi Mr. DI have downloaded the latest version V8.1.1.1436 (Or V8.1.0.1436 as it says in Help/About - Why the difference?).Referring to my initial posting, I get all the fields from Files A and B but none from File C, and in addition I get...

Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 17/12/13 at 11:47:59

Re:Re:Re:CSV files - Export To vs EXECDQL

Hi again.It might well be that the Export To doesn't work the same in ExecDQL as in Traditional DQL, but what I don't understand is why you use Export To?You don't need to use it in ExecDQL as it will generate the export "native".<...

Product: Dataease [{8}]FIVE. Written by DataEase 17/12/13 at 14:24:22

Re:Re:Re:Re:CSV files - Export To vs EXECDQL

Hi again Mr. DI do not use the EXPORT TO in my EXECDQL - I have simply pasted the DQL WITHOUT the EXPORT TO portion into my EXECDQLSTORE table. I then run it using the button at the bottom of the form and, as I have said before, I do not get t...

Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 17/12/13 at 14:30:37

Re:Re:Re:Re:Re:CSV files - Export To vs EXECDQL

Hi Again Peter.Sorry for being so slow.Can you send us a sample that show the difference and what you do.Send it to techsup@dataease.com...

Product: Dataease [{8}]FIVE. Written by DataEase 18/12/13 at 13:55:34

Calling MemoExecDQL From a Button

Second attempt for this entry.I am trying to create a button to call a DQL saved in ExecDQLStore under DQlNr 001MemoExecDQL( any ExecDQLStore with (DQLNr = "001") ,"" ,"","" ,"" ,"") ....

Product: Dataease [{8}]FIVE. Written by Graham Brown 09/03/14 at 17:48:31

Re:Calling MemoExecDQL From a Button

Hi Graham.You can't use ANY in a derivation. When using MemoExecDQL in a form you need to first lookup the DQL you want to use in a Virtual Memo and then execute it.This is a Data/Programming crossover where you store the DQL's as data...

Product: Dataease [{8}]FIVE. Written by DataEase 10/03/14 at 09:33:05

Calling a ExecDQL from with an ExecDQL

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by 25/03/14 at 12:58:36

Re:Calling a ExecDQL from with an ExecDQL

ExecDQL is just a function so you can simply call it like this.retval := MemoExecDQL(any DQLStore with DQLNr=006,"","","","","") ....

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 28/03/14 at 18:50:56

ExecDQL and in groups

Hi folks,in the last days I have been testing the use of MemoExecDQL / ExecDQL functions. It seems very powerful and I would like to use it instead the "null printer hack" to speed up and streamline my application. But during my tests I noticed...

Product: Dataease [{8}]FIVE. Written by George Washington 30/05/14 at 14:55:58

Re:ExecDQL and in groups

Is anybody in there?...

Product: Dataease [{8}]FIVE. Written by George Washington 11/06/14 at 06:31:28

Re:ExecDQL and in groups

Sorry for the late reply. We are currently working full out on 8.2 where DQL will be further enhanced.ExecDQL is DQL from "future" DataEase and is not derived from the existing DQL in DFW. Somewhere along the line someone "misunderstood" DQL a...

Product: Dataease [{8}]FIVE. Written by Mr. DataEase 11/06/14 at 11:02:44

ExecDQL

ExecDQL("for AUFTRAG with Belegnr=data-entry field1 ; modify records Bestellers:= "RRR" .", "Belegnr","","","","" )what is wrong? I want to update the aktual record.second question: I store my DQL's in a table "DQL" with DQLnr and DQLte...

Product: Dataease [{8}]FIVE. Written by Rainer 13/09/14 at 19:39:41

Re:ExecDQL

Hello Rainer. &nbsp;It is nice to see that sometimes we are "ahead" of the user ;-)Your problem here is that you are not seeing the forest for all the threes...The reason we very quickly implemented MemoExecDQL() followed by La...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 14/09/14 at 09:16:12

Re:Re:ExecDQL

thank's. I do not get a "error"now, but it does not do the update on the actual record?ExecDQL("for AUFTRAG with Belegnr=data-entry field1 ; modify records Bestellers:= /'RRR/' .", "Belegnr","","","","" )I tried also the memoexecdql<...

Product: Dataease [{8}]FIVE. Written by Rainer 15/09/14 at 06:56:08

Re:Re:Re:ExecDQL

"Belegnr"Now you send the string containing the word Belegnr to your DQL, When you reference a table or a column (field) you should Never use "".Anythng in "" will be passed as is to the function.So the correct derivation is:<br...

Product: Dataease [{8}]FIVE. Written by DataEase 15/09/14 at 11:35:39

Re:Re:Re:Re:ExecDQL

ok the execdql works I got it.butI tried also the memoexecdqlexcecute funktion:MemoExecDQL(DQL,Belegnr,"","","","")DQLstoremodify records in AUFTRAG with Belegnr = data-entry field1;&nbsp;Bestellers:= "rainer"...

Product: Dataease [{8}]FIVE. Written by Rainer 15/09/14 at 21:13:35

Re:Re:Re:Re:Re:ExecDQL

There is one thing one need to do in DE8 and that is to take a step back.Almost intentionally we do things "across" the established truths. With Functions like MoveObject, SetClass, MemoClass etc. we basically challenege the artificial limitat...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 16/09/14 at 08:18:15

Re:Re:Re:Re:Re:Re:ExecDQL

I understand all that. That is not my problem. I call the DQL from&nbsp;&nbsp;my "DQLstore" with the viruell MemoField/lookup etc.:modify records in AUFTRAG with Belegnr = data-entry field1; Bestellers:= "rainer" .and I have the Button "...

Product: Dataease [{8}]FIVE. Written by Rainer 16/09/14 at 10:11:58

Re:Re:Re:Re:Re:Re:Re:ExecDQL

1. Test the DQL in the form where you type it in first (ExecDQLStore). If it works there, then the problem is your lookup.2. Check that the DQL is looked up in the virtual Memo field in Auftrag. If you can see it there then it should work on your...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 16/09/14 at 12:27:53

Re:Re:Re:Re:Re:Re:Re:Re:ExecDQL

Hi again Rainer and thanks for the images.Again everything looks OK, but I see that you are running a DQL to modify the PRISM values (i.e. the same record you are viewing). This is a bad idea and depending on your Locking model "illegal".<...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 18/09/14 at 11:44:03

Execute Function / Derivation MemoExecDQL

What is the correct syntax to run a DQL Execstore&nbsp; from Execute Function ?MemoExecDQL(DQL0013,"","","","","")+Wait(0.1)+ DocumentClose()...

Product: Dataease [{8}]FIVE. Written by Graham Brown 22/10/14 at 13:23:46

Re:Execute Function / Derivation MemoExecDQL

What is the correct syntax to run a DQL Execstore from Execute Function ?MemoExecDQL(DQL0013,"","","","","")+Wait(0.1)+ DocumentClose()ExecDQLStore is just a table and you only use it because you need a place to save/edit the DQLs.<...

Product: Dataease [{8}]FIVE. Written by DataEase 22/10/14 at 19:30:38

MemoExecDQL

I have trouble starting a memoExecDQL out of a&nbsp;memoExecDQL using "global"&nbsp;define global "Belegnr" Numeric String 6.define global "Belegnr2" Numeric String 2.assign global Belegnr := data-entry Field1 .assign globa...

Product: Dataease [{8}]FIVE. Written by Rainer 08/11/14 at 09:46:04

Re:MemoExecDQL

I have to gather from your DQLs that this is just a test to explain the problem as it doesn't seem to make much meaning doing it like this ;-)1. The first problem here is that you haven't defined Retval so that would cause a problem when you t...

Product: Dataease [{8}]FIVE. Written by DataEase 10/11/14 at 06:33:59

Re:Re:MemoExecDQL

ok I understand I should not use "global" in execdql.in my "start out of a Form" atatched it works.but I learned now I should not do it....

Product: Dataease [{8}]FIVE. Written by Rainer 10/11/14 at 11:35:40

Re:Re:Re:MemoExecDQL

In my DQL0005 I have&nbsp;the problem I mentioned&nbsp;in my first question. I marked two versions at the end of the doc. The rest of this DQL0005 works very well. ( I still use "global" but only inside the DQL - it works - is that ok?)What do...

Product: Dataease [{8}]FIVE. Written by Rainer 10/11/14 at 11:42:25

Re:Re:Re:Re:MemoExecDQL

mybe the problem is this procedure. In DFD it works, but it does not work in normal DQL in DE 8.2 too. I try to update a related table.DQL No.0006:for AUFTRAG_POSITION withBelegnr = data-entry Field1 andBelegnr2 = data-entr...

Product: Dataease [{8}]FIVE. Written by Rainer 10/11/14 at 21:47:54

Re:Re:Re:MemoExecDQL

Hi!.We tested this too and it "works" but what you will find is that there is a delay in the Global Variable, so the first time it will not work then the next time it will but it will be the global value from the previous run. So this will see...

Product: Dataease [{8}]FIVE. Written by DataEase 11/11/14 at 09:07:58

Re:Re:Re:Re:MemoExecDQL

Does it work when you run it as ExecDQL but not when you try to run it as MemoExecDQL()?...

Product: Dataease [{8}]FIVE. Written by DataEase 11/11/14 at 09:14:39

Re:Re:Re:Re:Re:MemoExecDQL

I think you are in a relational loop here.DataEase always work on relationships so if there is a relationship between to table it will use the relationship and if there isn't it will create an "ad hoc" relationship.To make sure I would...

Product: Dataease [{8}]FIVE. Written by DataEase 11/11/14 at 09:16:02

Is there any difference in the syntax of the function MemoReplace used in a button or using MemoExecDQL?

Use this text in a button on the form order. This works as it should.SetValue("DQL_Nr" ,"104") + Wait(0.1) + MemoExecDQL( DQL ,"2","","","","") +Wait(1) + MemoReplace(settings,"[{filename}]",GetVar("VarSt...

Product: Dataease [{8}]FIVE. Written by Tor Nerland 12/11/14 at 09:42:53

Re:Is there any difference in the syntax of the function MemoReplace used in a button or using MemoExecDQL?

The syntax on a button and in a DQL is different but only in how you reference the column and when/where.In a form you will always have the PRISM column available but in a DQL it depends on where in the DQL you try to address it.1. Do yo...

Product: Dataease [{8}]FIVE. Written by DataEase 12/11/14 at 10:53:54

Re:Re:Re:Re:Re:Re:MemoExecDQL

Do you have an idea?I tried all, it does not have anything to do which DQL I use. (normal&nbsp;DQL, ecexdql, memoecexdql).I made a copy "AUFTRAG_POSITION_1" and it worked. Then I deleted it and I made a copy again to "AUFTRAG_POSITION" a...

Product: Dataease [{8}]FIVE. Written by Rainer 17/11/14 at 15:33:54

Re:Re:Re:Re:Re:Re:Re:MemoExecDQL

p.s. wenn I do:for AUFTRAG_POSITION with ...;list recordsany ARTIKEL Bestand .it works - no problem?...

Product: Dataease [{8}]FIVE. Written by Rainer 17/11/14 at 16:09:08

Re:Re:Re:Re:Re:Re:Re:Re:MemoExecDQL

We are sorry but you ask for an involvement in your application that we can't offer on here. We can answer simple request on specific problems, but we can't go into depth on application specific problems....

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup. 17/11/14 at 18:23:26

Re:Re:Re:Re:Re:Re:Re:Re:Re:MemoExecDQL

ok I found the problem, it was a loop (circular reference).But I have still the problem marked in the adattched file. I coloured it. The ecexdql works, but the MemoExecDQL not....

Product: Dataease [{8}]FIVE. Written by Rainer 19/11/14 at 14:20:03

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:MemoExecDQL

I guess we have done the same as you.We have been staring on the code and can't see any difference...1.There is no difference between execDQL and MemoExecDQL when the code id loaded i.e. executing it is the same.2. So the problem m...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup. 19/11/14 at 19:44:12

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:MemoExecDQL

you are right. The memoexecqdl is not called at all. I tryed just to call a "massage("is it working") window." and it did not work either. Could it bee, That it does not work because of the "case value"?...

Product: Dataease [{8}]FIVE. Written by Rainer 20/11/14 at 11:09:59

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:MemoExecDQL

some more info's. I put the Memoexecdql on the beginning of the DQL 0005 before the "case" statement. it works. and at the end after the last "end". it does not work.wenn I&nbsp;start it out of an empty Form it works both on the beginning and a...

Product: Dataease [{8}]FIVE. Written by Rainer 20/11/14 at 11:58:12

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:MemoExecDQL

please answere...

Product: Dataease [{8}]FIVE. Written by Rainer 26/11/14 at 07:50:42

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:MemoExecDQL

Dear Rainer and the rest of you.This is an open user forum and not a DataEase support forum. Request on here will be answered by anyone that feel they have the inclination or time to answer/help. There is no limitations to what one can put on...

Product: Dataease [{8}]FIVE. Written by DataEase 26/11/14 at 09:23:28

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:MemoExecDQL

Dear &hellip;I am not asking you, to involve in my client system.Wenn you read my last two statements, it seems, that the menoecexdql does not load in combination with the “case value” statement. That would be a bug and of general intere...

Product: Dataease [{8}]FIVE. Written by Rainer 26/11/14 at 14:35:03

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:MemoExecDQL

Download Sample on Simple Sample Dear Mr. Köllensperger. Cases and MemoExecDQL() has been used extensively so it is not the combination in itself that goes wron...

Product: Dataease [{8}]FIVE. Written by DataEase 26/11/14 at 14:35:52

MemoExecDQL

I am looking a bit around on the new MemoExecDQL function, so I downloaded the MemoAndExecDQLSample, but for the life of me I cannot find out what credentials to use to have full access and see the source code....

Product: Dataease [{8}]FIVE. Written by George Washington 07/01/15 at 08:07:23

Re:MemoExecDQL

Have you tried&nbsp;http://www.dataease.com/DG3_BlogList/?ParentID=000...alsoHow to get it to work.Download and install the lat...

Product: Dataease [{8}]FIVE. Written by Kensington 07/01/15 at 11:11:56

Re:MemoExecDQL

You might want to check the version of your DataEase.In DE8.2 you should always be able to switch to Design Mode if you are logged in with a High user.&nbsp;The developer is for developing/testing so logging in with a startup-document...

Product: Dataease [{8}]FIVE. Written by DataEase 07/01/15 at 13:01:23

Re:Re:MemoExecDQL

That's it, High - High, you should put them in a README.TXT file inside the zip package....

Product: Dataease [{8}]FIVE. Written by George Washington 08/01/15 at 10:12:10

Suspected MemoExecDQL issue

HiBTW: I am using version 8.2.0.1619. Not sure whether this makes any difference.I thought this was an issue with my client?s database.But, since this is happening on a second database (different client).I am pretty sure th...

Product: Dataease [{8}]FIVE. Written by Arul 26/02/15 at 07:17:12

Re:Suspected MemoExecDQL issue

Hi Arul.I played with your problem a little.0. General ;-) All support is based on latest released version of the product. Before contacting support, the problem should always be tested in the latest release version first. 1. The...

Product: Dataease [{8}]FIVE. Written by DataEase 26/02/15 at 07:19:06

Re:Re:Suspected MemoExecDQL issue

Thank you for taking your time to check this out.In regards to the latest version, it is not always possible to keep the application updated.When you (as a vendor) cannot provide guarantee everything in the application will work after up...

Product: Dataease [{8}]FIVE. Written by Arul 26/02/15 at 14:36:05

Re:Re:Re:Suspected MemoExecDQL issue

All relationships are ad-hoc as such, the difference is only how they come about i.e. from a stored table or in a stored script or properly ad-hoc like in ExecDQL&hellip; Anyway, what I say is that the problem is that the relationship does...

Product: Dataease [{8}]FIVE. Written by DataEase 26/02/15 at 14:36:29

Re:Re:Re:Re:Suspected MemoExecDQL issue

I am still puzzled why it fails when I call it directly like;tN := MemoExecDQL (any DQLStore with (DQLNo = 015) DQLScript , "" , "" , "" , "" , "") .BUT, it works when I do something like this;tN := MemoEx...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 27/02/15 at 18:40:45

Re:Re:Re:Re:Re:Suspected MemoExecDQL issue

We have tested all of these cases, and all work. We haven't tested it in1619 though but in 1700.Again we need to state that the problem is with the lookup/relationship and not with MemoExecDQL(), if you tried to lookup the value rather than ex...

Product: Dataease [{8}]FIVE. Written by DataEase 28/02/15 at 14:18:41

ExecDQL problem with syntax.

ExecDQL("modify records in contract with (selected = yes), selected = blank.","","","","","")+SetLabelText("Status","All Selected set to Blank!.")?Should that work? just trying not to do a dql, but can....

Product: Dataease [{8}]FIVE. Written by Dave 22/06/15 at 08:53:08

Re:ExecDQL problem with syntax.

No. This should not work as the syntax is wrong.This is the synxtax for a direct Modify Records without a for.modify records [in TABLENAME|RELATIONSHIP] [named "UNIQUE RELATIONSHIP NAME"...

Product: Dataease [{8}]FIVE. Written by DataEase 22/06/15 at 09:00:48

ExecDQL simple Report with grouping.

Download Sample! Just for fun we made the same report with the New Exec...

Product: Dataease [{8}]FIVE. Written by DataEase 23/06/15 at 09:25:04

Re:ExecDQL simple Report with grouping.

I have used summary feature in the header since the DFW introduction.&nbsp;But, even that does not work when you have a second page.Even second page. Then I have to place the field into .ITEMS area. Even that fails when 3rd page does not have the...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 23/06/15 at 12:52:17

Re:Re:ExecDQL simple Report with grouping.

Yes, I agree that we should use the new features in DE8. This is ok for the new and future clients.But, question comes, do I need to upgrade/update my clients each time when there is a new feature in DE8??Even though it is a free update for...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 23/06/15 at 13:27:46

Re:Re:Re:ExecDQL simple Report with grouping.

BTW: client using 8.2. And this new feature formatted body is 8.5 right?...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 23/06/15 at 13:34:58

Re:Re:Re:ExecDQL simple Report with grouping.

You obviously don't have to update a client if you don't use any of the new functionality. You can keep them in any version you like as long as they and you are happy, but equally obviously you can't use a new feature without updating the software.<br...

Product: Dataease [{8}]FIVE. Written by DataEase 23/06/15 at 13:49:48

Re:Re:Re:Re:ExecDQL simple Report with grouping.

Yes, this is the latest feature in DE8 and is as such only available in the latest 8.5.8.2 Development was concluded last year (2014)....

Product: Dataease [{8}]FIVE. Written by DataEase 23/06/15 at 13:55:56

Re:Re:Re:Re:Re:ExecDQL simple Report with grouping.

Problem I always face. Client running 8.2 without any issues for a while. Wants some enhancements done. Either I have to update them to 8.5 and use the new features. Which means, I have to provide gurantee it will not break anything else. Or find a wo...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 23/06/15 at 14:00:31

Re:Re:ExecDQL simple Report with grouping.

There is a lot of "awkward" &nbsp;behaviour but. 1. It works if you print it rather than use Print to Screen. 2. It works when Print to screen if you use arrow down rather than PageDown. 3. The problem with the extra text is that it b...

Product: Dataease [{8}]FIVE. Written by DataEase 23/06/15 at 15:36:39

Re:Re:Re:ExecDQL simple Report with grouping.

Actually, I do have a workaround which works every single&nbsp;time. I was giving this problem, and hoping you will show me something to make DataEase....EASY..... rather than HARD.Only workaround works every single time is to use Holding table...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 23/06/15 at 17:37:40

Re:Re:Re:Re:ExecDQL simple Report with grouping.

I rest my case ;-)&nbsp;I am building you a new DQL, what more can I do? I think my view on the existing DQL implementation has been clear since the start. I think I have been clear from the start that NEW is our focus, not mending old...

Product: Dataease [{8}]FIVE. Written by DataEase 23/06/15 at 18:17:56

Fields order on DBE and exporting with ExecDQL

Export via DQL would definitely solve this problem and I might be intentionally obtuse when I say I don't understand what you mean when you say that this function is particularly slow... ;-)You mean of course the horrible export to file stuff t...

Product: Dataease [{8}]FIVE. Written by DataEase 23/06/15 at 21:13:15

PDFplay in DE8.5 using MemoExecDQL and HTML.

Hmmm...&nbsp;With one hand you preach DataEasy and with the other advanced functionality ;-) GOOD!You can store the result of a DQL as a Text (HTML) file, you can save it in a Memo etc. When you have finished all your reports you can s...

Product: Dataease [{8}]FIVE. Written by DataEase 07/07/15 at 14:22:43

Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

Unable to download the sample................

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 07/07/15 at 14:48:37

Re:Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

Just tested and it works fine. Maybe it is your virus software that block it. It is a zip file, the have a tendency to not like them to muc.http://www.dataease.com/static/ulimages/PDFPlay.zip...

Product: Dataease [{8}]FIVE. Written by DataEase 07/07/15 at 16:48:19

Re:Re:Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

Yes, something was wrong with my Chrome. Tried it under IE, it worked. I guess IE wins!!...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 08/07/15 at 13:32:19

Re:Re:Re:Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

Don't be to quick to assume that Arul ;-)They all have their weaknesses and strengths. To get background image on Body is much harder in IE than in Chrome/Firefox that is why in this sample you have full paths etc.In a way it was a goo...

Product: Dataease [{8}]FIVE. Written by DataEase 08/07/15 at 13:45:45

Custome TableView/FormView Toggle, fun with LabelExecDQL, SetClass, Custom Menu, Custom Toolbar, MoveObject etc...

Since we made you cry over the weekend, and your "challenge" is an interesting one that give us plenty of opportunity to confuse you and everyone else even further we couldn't stop ourselves from putting aside some time and make a sample/solution/chal...

Product: Dataease [{8}]FIVE. Written by DataEase 13/07/15 at 19:09:21

Re:Custome TableView/FormView Toggle, fun with LabelExecDQL, SetClass, Custom Menu, Custom Toolbar, MoveObject etc...

Thank you firstly.&nbsp; Having an example to work off helps masssively.I managed to get the saving corrrect record in table view sussed pretty quick, having a temporary variable with the exact same name as a field confused me as I didn't reali...

Product: Dataease [{8}]FIVE. Written by Simon B 15/07/15 at 10:55:41

How do I run more than 1 Delete Records in an EXECDQL

Morning,It is me again ... Hope you are well.I have a two Questions (for now ......)How do I run more than 1 Delete Records in an EXECDQL ? egDelete records in FORMAdelete records in FORMBdelete recor...

Product: Dataease [{8}]FIVE. Written by Charmaine 25/09/15 at 07:48:34

Re:How do I run more than 1 Delete Records in an EXECDQL

Hi Charmaine. To be honest, you should get all away from using old style DQL?s (for new stuff, don?t have to rewrite stuff of course). ExecDQL is ?million? times faster, close t...

Product: Dataease [{8}]FIVE. Written by DataEase 25/09/15 at 07:56:54

Use ExecDQL instead of traditional DQL - Calendar database

EXEC DQL is Very interesting way of programming but Can I get a sample database with Calendar in version 8.2 ? (pls see blog) Thanks...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 15/10/15 at 13:19:36

Re:Use ExecDQL instead of traditional DQL - Calendar database

Hi. This will NOT work in 8.2It uses all new features that is only available in 8.5...

Product: Dataease [{8}]FIVE. Written by DataEase 16/10/15 at 16:26:35

Re:Re:Use ExecDQL instead of traditional DQL - Calendar database

The Calendar here is simply a DQL with body like this. I use the same DQL script for all my calendars, then just make different layout You see the strength of DQL vs. normal techn...

Product: Dataease [{8}]FIVE. Written by DataEase 21/10/15 at 08:46:54

Formatting of export in ExecDQL

Been&nbsp; sleeping in class again Arul? ;-)It is a long time since ExecDQL surpassed traditional DQL when it comes to opportunities for both design on output, output methods and formatting of Exports.ExecDQL even surpass DFD in this a...

Product: Dataease [{8}]FIVE. Written by DataEase 17/11/15 at 07:29:30

Re:Formatting of export in ExecDQL

Yes, you are right. I fell asleep as DataEase functions are&nbsp;getting way too much :-)Anyways, problem I am facing. My client running 8.1. So, I can only use what is available in that version.They are into the application deep&nbsp;way t...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 17/11/15 at 14:11:31

Re:Re:Formatting of export in ExecDQL

Again, problem with ExecDQL. We cannot check for syntax errors.- will this feature be enabled one day ?...

Product: Dataease [{8}]FIVE. Written by Kensington 17/11/15 at 15:11:50

Re:Re:Formatting of export in ExecDQL

Again Sleeping in class are we ;-)Of course you can check for syntax, there is absolute 0% difference in the checking of Syntax in ExecDQL and "tradtional" DQL. You get the same "errors" in...

Product: Dataease [{8}]FIVE. Written by DataEase 18/11/15 at 09:58:14

Re:Re:Re:Formatting of export in ExecDQL

To make and ExecDQL editor with the same level of "complexity" as the Traditional (DFW) editor can be done in an hour by anyone.Syntax checking is there and has always been there on the exact same level as for traditional DQL, only difference i...

Product: Dataease [{8}]FIVE. Written by DataEase 18/11/15 at 10:08:37

How do you do GROUPS in ExecDQL body?

Long time no speak !!! How are youWe are doing well , looking for to the Christmas HolidaysI have and ExecDQl Query again .........We have procedures with Group Headers and Group trailers ....... How do we do this in the Body , I...

Product: Dataease [{8}]FIVE. Written by charmaine smit 27/11/15 at 07:53:48

Re:How do you do GROUPS in ExecDQL body?

Download Sample! NB! This sample use LabelExecDQL but it will be the same in MemoExecDQL.&nbsp; Hi Charmaine. ExecDQL Layou...

Product: Dataease [{8}]FIVE. Written by DataEase 27/11/15 at 08:02:02

HTML/FRM Crossover AKA Calendar with ExecDQL()

Download Calendar Sample It is Christmas after all so why...

Product: Dataease [{8}]FIVE. Written by DataEase 30/12/15 at 15:09:30

Re:HTML/FRM Crossover AKA Calendar with ExecDQL()

Thank you for this Christmas. Become now unwrap the gift and experiment with it and learn how it works ..... :)HAPPY NEW YEAR !!Markus...

Product: Dataease [{8}]FIVE. Written by grohmann.papier@t-online.de 30/12/15 at 19:01:02

Iam try studying your example MemoAndExecDQLSample in your sample and it come out question.

Its there have (setglobal)?...

Product: . Written by Mohd Sedik Zakaria 12/04/16 at 01:35:11

Re:Iam try studying your example MemoAndExecDQLSample in your sample and it come out question.

The two functions&nbsp;SetGlobal() and GetGlobal() have been renamed to&nbsp;SetVar() and GetVar()&nbsp;after the release of DE8 Classic. The sample application is using the old CDFs, so you just need to edit the Action of the button to be:...

Product: . Written by Fatma Adel 12/04/16 at 09:36:05

Re:Re:Iam try studying your example MemoAndExecDQLSample in your sample and it come out question.

and don't forget to edit it in the two forms "LoanAgreementEdit" and&nbsp;LoanAgreement" as well....

Product: . Written by Fatma Adel 12/04/16 at 10:54:27

On the blog about ExecDQL

DataEase 8 - Forward Talk! ExecDQL(), MemoExecDQL() & FileExecDQL()

In DataEase 8 we try to break stuff down into simple functions so you can use it as LEGO bricks and make whatever you like. Simple but powerful. When developing DG3 we looked at DFW, DataEase 7 and WebPublsiher as standards of how "not" to do things....

Product: Dataease [{8}]FIVE. Written by DataEase 01/03/13 at 13:36:04

DataEase 8 - Best Practice Dynamic Document Generation/Editing ExecDQL/Memo/SetVclass (Ver 8.0.0.1273)

I have been playing around a little with DataEase 8 and generated a simple sample on how to generate documents for further editing by combining the new function classes in DataEase 8. I hope and think that this will show that the time of generating W...

Product: Dataease [{8}]FIVE. Written by DataEase 14/04/13 at 18:49:17

New Sample - Data Export in DQL, ExecDQL and with DataExport() explained!

Download SampleIt is no secret that data export which used to be so easy and natural in DFD has been a nightmare in DFW. Especially the DQL export.If you do a...

Product: Dataease [{8}]FIVE. Written by DataEase 25/07/13 at 18:24:45

Small Sample - ExecDQL() Show manipulation of Data/Form/Documents/AutoClose...

Download Sample One of the big news in DE8 is ExecDQL() and we are sorry that it hasn't been properly documented and promoted yet. Hopefully there is so muc...

Product: Dataease [{8}]FIVE. Written by DataEase 13/09/13 at 14:47:24

New Sample - DQL with no output and the superiority of ExecDQL over traditonal DQL... You won't believe it!

Download Sample If you are just looking for a way to "fool" DataEase into not generating any visual output there is several ways, just remember that all...

Product: Dataease [{8}]FIVE. Written by DataEase 16/09/13 at 13:31:43

Nifty little ExecDQL sample (A lot of you ask what is the point....see for yourself!)

Download Sample!One thing we will try to do more and more is to showcase the functionality in our products. It is not much point in us making it if nobody use i...

Product: Dataease [{8}]FIVE. Written by DataEase 19/11/13 at 18:23:25

New Function in 8,1 - LabelExecDQL() - Execute the Script stored in a label (Ver. 8.1.0.1521)

We are rushing ahead and the full documentation will follow, but for those of you that have embraced the ExecDQL class have come across some challenges. ExecDQL() the normal PRISM function is limited to 255 and if you want to write the DQL dir...

Product: Dataease [{8}]FIVE. Written by DataEase 01/04/14 at 16:12:14

Re:New Function in 8,1 - LabelExecDQL() - Execute the Script stored in a label (Ver. 8.1.0.1521)

Remember when calling a LabelExecDQL() that you are reading a GUI object not a PRISM column.This means that the name of the object needs to be in "" ex. LabelExecDQL("MyDQL","","","","","")&nbsp;You can rename a label by right-clic...

Product: Dataease [{8}]FIVE. Written by DataEase 24/04/14 at 08:49:04

DataEase 8.5 BETA - .header .items .end DFD style HTML body on MemoExecDQL (Ver. 8.5.0.1815)

Download Sample!Download app, unzip and start it up from DE8.5.1815 or later.Username: HighPassword: High<br...

Product: Dataease [{8}]FIVE. Written by DataEase 05/06/15 at 18:55:35

Re:DataEase 8.5 BETA - .header .items .end DFD style HTML body on MemoExecDQL (Ver. 8.5.0.1815)

I have not tried it yet. But this sounds amazing.I will try over the weekend....

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 06/06/15 at 01:41:39

Re:DataEase 8.5 BETA - .header .items .end DFD style HTML body on MemoExecDQL (Ver. 8.5.0.1815)

wow!I used to do this by writing a mini exe....

Product: Dataease [{8}]FIVE. Written by 06/06/15 at 01:41:39

PDFplay in DE8.5 using MemoExecDQL and HTML.

Download Sample! PS! You will need the latest version of DE8.5 BETA to run this sample, you will fin...

Product: Dataease [{8}]FIVE. Written by DataEase 07/07/15 at 11:49:54

Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

WOW!This is very good. My next project will be in 8.5......no question about it.BTW: since you are building "SR-71 Blackbird"....I thought no harm in asking :-)...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 07/07/15 at 14:36:56

Re:Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

He,he!&nbsp;Never harm in asking. It is your best "skill" that you are never afraid of asking the question. If one don't ask one won't get an answer....

Product: Dataease [{8}]FIVE. Written by DataEase 07/07/15 at 15:41:00

Custome TableView/FormView Toggle, fun with LabelExecDQL, SetClass, Custom Menu, Custom Toolbar, MoveObject etc...

Downlaod Sample! We had a request the other day about manip...

Product: Dataease [{8}]FIVE. Written by DataEase 13/07/15 at 16:48:31

Sample! SimplePDF, learn how to use ExecDQL to create PDF quick and easy!

Download Sample! This sample might be a little out of "context" as we have had this feature in DE85 for "many" weeks alre...

Product: Dataease [{8}]FIVE. Written by DataEase 07/08/15 at 09:16:50

Why should I use ExecDQL rather than traditional DQL?

ExecDQL is “million” times faster, close to 100% stable (I know how the DE community love that word&hellip;), it can be used anywhere and without any “detrimental”...

Product: Dataease [{8}]FIVE. Written by DataEase 25/09/15 at 08:01:46

Re:Why should I use ExecDQL rather than traditional DQL?

Very interesting way of programming! Can I get a sample database with Calendar in version 8.2 ? Thanks....

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 15/10/15 at 08:53:43

DataEase 8.5 - Simple ExecDQL Report, Groups explained!

Download Sample! NB! This sample use LabelExecDQL but it will be the same in MemoExecDQL.&nbsp; ExecDQL Layout is a NEW functiona...

Product: Dataease [{8}]FIVE. Written by DataEase 27/11/15 at 10:15:23

Simple Calendar in DE85 using ExecDQL with Body ver 1.0 - Will be continued....

Download Calendar Sample It is Christmas after all so why not give you guys another little "present" ;-...

Product: Dataease [{8}]FIVE. Written by DataEase 30/12/15 at 15:29:44

Re:Re:DataEase 8.5 BETA - .header .items .end DFD style HTML body on MemoExecDQL (Ver. 8.5.0.1815)

Hi Dataease, I downloaded your sample in order to understand what I have to do for create an html layout without knowing the html language (source). I'm now using ckeditor but I have some difficult within the body (htmledit). Any suggestion...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 25/10/16 at 10:31:48

Re:Re:DataEase 8.5 BETA - .header .items .end DFD style HTML body on MemoExecDQL (Ver. 8.5.0.1815)

Hi Dataease,I'm using htmledit fields in order to obtain a more elegant and modern layout for my reports but I have some trouble to use it without knowing html language. I'm trying to use ckeditor for this but it's not so easy to use especially...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 25/10/16 at 11:51:39

New Sample : ExecDQL, LabelExecDQL, MemoExecDQL Showcased and explained!!!

Download Sample! Not all of us has got to grips with the concept of ExecDQL so we have taken some...

Product: Dataease [{8}]FIVE. Written by DataEase 17/03/17 at 17:09:04

Re:New Sample : ExecDQL, LabelExecDQL, MemoExecDQL Showcased and explained!!!

this is all very nice.Does it work with "any"&nbsp;as well?&nbsp;Examplefor PERSONAL with ( Austritt &gt;= data-entry Field1 or Austritt = blank ) and Eintritt &lt;= data-entry&nbsp;Field1&...

Product: Dataease [{8}]FIVE. Written by Rainer 17/03/17 at 21:12:27

Re:Re:New Sample : ExecDQL, LabelExecDQL, MemoExecDQL Showcased and explained!!!

Of course. You ca do anything you can in "traditional" DQL and then some. It is however very awkward to include tags that [{any ERFASSUNG with ( Tag = Field1 and MANR = PERSONAL MANR ) BewegungsartNR}] So the best cause of action is...

Product: Dataease [{8}]FIVE. Written by DataEase 19/03/17 at 20:31:09

New Sample - How to do multiple automated exports with ExecDQL()

Download Sample I know we keep on harping on this but DQL is DQL, syntax wise that is true at least. <b...

Product: Dataease [{8}]FIVE. Written by DataEase 02/07/17 at 16:54:26

DE8.5 - How to make generalised Language Version with ExecDQL and GetCurrent() etc.

Download Sample How to create language versions of documents has been discussed before. How to acheive t...

Product: Dataease [{8}]FIVE. Written by DataEase 09/06/20 at 18:50:01

LE9-How to call ExecDQL directly from code

ExecDQL started small and is now all-encompassing. What started as a way to execute a DQL for processing with no output now powers websites and has taken on a life on its own w...

Product: LegEasy 9 Developer. Written by DataEase 08/11/24 at 15:16:23

Re:LE9-How to call ExecDQL directly from code

excellent.will try. thx.Glory to DataEase Team!...

Product: LegEasy 9 Developer. Written by Ihor Zakharchenko 08/11/24 at 15:35:11


dg3_HelpView