Simplicty and flexibility!


Function::Memo

MemoExecDQL
MemoExecDQL(DQLMemoField,"Data-Entry Field1","Data-Entry Field2","Data-Entry Field3","Data-Entry Field3","Export File")
MemoExecDQL(MyMemo,MyDataEntry1)


MemoExecDQL is the most used ExecDQL function simply because you can make your own editor form in an application where you store all your DQLs and then you transfere them to the form where they are needed via a simple lookup to a virtual memo field.

When it is looked up in the virtual memo field, you can simply execute it in the form via MemoExecDQL().

You can execute a DQL up to 64k in length this way.

Parameters


MemoContianingDQL: (Field)

Field name (Memo field) that contain the DQL you want to execute.

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.

Output: (Field)

There is several different output modes for MemoExecDQL.

File: (Default)

If you use the reserved keyword file: or refrain from using a reserved keyword in the Output argument the argument will be interpreted as a text file and the export will be saved in this file name.

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

 Web:

This is the HTML mode. The output will now be interpreted as HTML and you can either Print it or Preview the output in the IE object. When using the Web: keyword you have extra formatting.

Web:<printer>,<mode> ex. MemoExecDQL(DQL,"","","","","web:Default,1",Layout) -- this will preview the Result in the IE object.

<printer> -- Default, Printer1..Printer4, Actual name of printer. -- The default printer in WIndows will be changed to this printer.
<mode> -- 0,1 - Preview, 2 - Print Directly to printer without dialog, 3 - printer dialogue.

 PDF:

Print directly to PDF. PDF:<filename>. Ex. MemoExecDQL(DQL,"","","","","PDF:c:\test\mypdf.pdf",Layout)

Memo:

Will put the output directly into a Memo GUI control in the active form. If the GUI control is a WebField it will display HTML correctly.
PS! If you output formatted text to a text memo, remember to use COURIER or another fixed position font.

Layout:

This is a Memo where the layout format for the DQL is stored. Format:

Report Header: Free text that will come at the beginning of the report. Never repeated!

.header.
,items
.footer
.end

Tags: [{column name}]
EkstraTags: 
Position: LRW ex. L30, R20, C10
[{Price:R15}] -- print Price R oriented 15 spaces.
[{Price:R15 sum}] -- print the sum off Price listed in List Records Price : sum ;
Integer to float European: [{var1:F999 999 999,99}]
Integer to float C type: [{var2:F999999999.99}]
Integer fixed leading 0s: [{var3:F00000}]
Integer to with fixed length: [{var4:F99999999}]
Float just formatet: [{var5:F999 999 999,99}]
Float to Integer: [{var6:F99999}]
Float C more dec: [{var7:F999999.999999}]
Float European more dec: [{var7:F999999,999999}]

When combining formatting and statistical the statistical need to come last.

[{Price:R15 Sum}] or [{Price:F99999.99 sum}] or [{CustomerNr:L4 Count}]

.page -- will send HTML page break.

<br><br><pre></pre>

If you use this tag around your output, the resulting code will be treated as TEXT i.e. space, line feed and position will be honoured (DFD mode)

Returns/Result


Nothing

Examples


Example 1: Simple Order printed to Memo.

DQL:
for OrderHead with OrderNr = Data-entry field1 ;

list records

OrderNr ;

Customer ;

Address ;

Address1 ;

PostCode ;

Town ;

Terms;

OrderTotal ;

DueDate .

for OrderLine

list records

Description ;

Price ;

Count ;

LineTotal : item sum ;

LineTotal*0.2 : sum ;

LineTotal+LineTotal* 0.2 : sum .

end

Body:

.header

Order nr.: [{OrderNr}]

To:

[{Customer}]

[{Address}]

[{Address1}]

[{PostCode}]

[{Town}]

Terms: [{Terms}] days. Due date: [{DueDate}]

Description Price0 Count LineTotal

-----------------------------------------------------------------------------------------------------

.items

[{Description:L40}][{Price:R10}][{Count:R8}][{LineTotal:R17}]

.footer

-----------------------------------------------------------------------------------------------------

OrderTotal : [{LineTotal:R50 sum}]

=====================================================================================================

.end

End of report....


Button Code:

MemoExecDQL(DQL,OrderNr,"","","","Memo:Result",Body)

Reference

See Also



CHR()


GetValue()

ExecDQL()

LabelExecDQL()

TextExecDQL()

StringEscape()

On the forum about MemoExecDQL

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

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

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

DQL export using MemoExecDQL with 2 tables

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

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

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...

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

Re:Re:DQL export using MemoExecDQL with 2 tables

Hi DataEase,ExecDQL works fine even if I use&nbsp; .export&nbsp;directly in the function. It doesn't work only&nbsp;if I have two different table as originally requested.using&nbsp; MemoExecDQL(DQL,"","","","","")...

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

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...

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

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

Just to illustrate. 8.5 will also handle nested for sentences etc. ...

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

Running a MemoExecDQL from a MemoExecDQL

One more problem that I don’t understand ( I’m afraid it’s again me)I use this command in an Action (on a button). There it runs without error..retval := MemoExecDQL( any AADQLStore with DQLNr=151 DQL, data-entry field1, data-entry fiel...

Product: Dataease [{8}]FIVE. Written by Thomas 19/08/16 at 21:22:40

Re:Running a MemoExecDQL from a MemoExecDQL

Hi Thomas. 1. You say that this works on an Action on a button&hellip;. retval := MemoExecDQL( any AADQLStore with DQLNr=151 DQL, data-entry field1, data-entry field2 , data-entry field3 , data-entry field4 , concat("file:"...

Product: Dataease [{8}]FIVE. Written by DataEase 19/08/16 at 21:25:42

MemoExecDql used to export the document to PDF.

Need to print A4 report landscape format. Has made some effort, but could not generate another or vertically (portrait). Are there any opportunities for change style settings to the desired format....

Product: Dataease [{8}]FIVE. Written by Tor Einar Nerland 05/01/17 at 09:44:29

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

this is all very nice.Does it work with "any" as well? Examplefor PERSONALwith( Austritt &gt;= data-entry Field1 orAustritt = blank ) andEintritt &lt;= data-entry Field1 andFreigabe = "J"and<...

Product: Dataease [{8}]FIVE. Written by Rainer 19/03/17 at 19:44:04

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 simp...

Product: Dataease [{8}]FIVE. Written by DataEase 19/03/17 at 19:49:36

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

I tried to combine&nbsp;MemoExecDQL(DQL,von,"","","","Web:Default,1",Body) withretval := MemoExecDQL(any DQL with DQLnr=0003 DQL,data-entry field1,"","","","").but the output I get only the group and not the item lines. see pdf 2...

Product: Dataease [{8}]FIVE. Written by Rainer 31/03/17 at 10:49:37

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

The problem is the multi-view that is generated.We base ExecDQL on the internal multiview in PRISM which is dynamic and extremly flexible.When you add a dimension you add another level.A dimention is a relational action like<br...

Product: Dataease [{8}]FIVE. Written by DataEase 31/03/17 at 14:31:11

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

I fire&nbsp;a "control" DQL that fire both DQLs withMemoExecDQL(DQL,von,"","","","Web:Default,1",Body)define "retval" text .retval := MemoExecDQL(any DQL with DQLnr=0003 DQL,data-entry field1,"","","","")....

Product: Dataease [{8}]FIVE. Written by Rainer 31/03/17 at 16:45:35

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

MemoExecDQL is a function and each function is self-contained.Each of these could produce their own output. There is no "cross-over" between them and it is no voodoo or magic.When you call the MemoExecDQL it will do its job with the ar...

Product: Dataease [{8}]FIVE. Written by DataEase 31/03/17 at 17:01:26

Export using ?MemoExecDQL

I was using the following function to export dataMemoExecDQL(DQLMemoField,"Data-Entry Field1","Data-Entry Field2","Data-Entry Field3","Data-Entry Field3","Export File")But, header came in just like what is in the list records.For...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 28/09/18 at 15:31:10

Re:Export using ?MemoExecDQL

MemoExecDQL come with full formatting of body etc like DFD.So the only thing you need to include is a format Memo.MemoExecDQL(DQLMemoField,"Data-Entry Field1","Data-Entry Field2","Data-Entry Field3","Data-Entry Field3","Export File",DQLMem...

Product: Dataease [{8}]FIVE. Written by DataEase 01/10/18 at 18:24:20

Re:Re:Export using ?MemoExecDQL

MemoExecDQL(DQLMemoField,"Data-Entry Field1","Data-Entry Field2","Data-Entry Field3","Data-Entry Field3","Export File",DQLMemoFormat)Is this available in 8.5 ?...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 02/10/18 at 18:37:48

Re:Re:Re:Export using ?MemoExecDQL

Yes, defiinitly. Have been for quite some time too....

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

MemoExecDQL

Hi all,I've a button with a execute Function/derivation with a set of instructions as follows :if ( cod1 not = blank and cod11 not = blank, setstate ( "b_geracao", 2) + setValue("DQLNr","432")+Wait(0.1)+MemoExecDQL(DQL,cod1 ,cod11,"","",...

Product: Dataease [{8}]FIVE. Written by afonso santos 22/10/19 at 01:05:41

Do and don't when using ExecDQL, MemoExecDQL, delete records in etc.

Hi Afonso.Nobody can say that you haven't embraced the new ideas in DE8 ;-)The DE8 project was very much about "releasing" DataEase from its constraints and as such it has been a learning experience for all of us.The development...

Product: Dataease [{8}]FIVE. Written by DataEase 25/10/19 at 10:58:17

Re:Do and don't when using ExecDQL, MemoExecDQL

Thanks for the great explanationSome videos with real examples would be helpful as in the past with the old DW6.2 CD'sFish4Support Videos were good but unfortunately not updated...

Product: Dataease [{8}]FIVE. Written by afonso santos 29/10/19 at 00:34:47

Re:Re:Do and don't when using ExecDQL, MemoExecDQL

Hi again Alfonso.Later this week we "release" the first official pre-release version of DE9. From then on till full release it will all be about function and functionality.DE9 Pre-release will be all about getting existing users to star...

Product: Dataease [{8}]FIVE. Written by DataEase 29/10/19 at 16:05:57

subform+MemoEXECDQL

Dear all,I've a subform with a button on each record with a OML event click as follows :act :=&nbsp;SetValue(concat("DQLNr1#",row.value),"510")+Wait(0.1)+MemoExecDQL(DQL1,codigo.value,quantidade.value,encomenda_cliente,"","").Unfo...

Product: Dataease [{8}]FIVE. Written by afonso santos 25/03/20 at 23:26:47

Re:subform MemoEXECDQL

Hi Afonso.There is a couple of things to clear up here.OML and "Normal" Dataease fields work quite differently.Here I fear that you have ended up in a muddle.I will explain what has gone wrong but maybe show you the bes...

Product: Dataease [{8}]FIVE. Written by DataEase 27/03/20 at 14:29:18

Re:Re:subform MemoEXECDQL

Hi,Tks for the answer."act := MemoExecDQL(any ExecDQLTableYouUse with DQLNr=510 DQL,codigo.value,quantidade.value,encomenda_cliente,"","") .This is just pure Dataease OML/DQL and there is no magic. you lookup the DQL with a standa...

Product: Dataease [{8}]FIVE. Written by afonso santos 27/03/20 at 23:57:26

Re:Re:Re:subform MemoEXECDQL

As I don't have your application I can't point specifically what you do wrong but based on your reply I think you are still on the "wong page".any t_execucaoDQL with DQL_Nr = 510 DQLthis is a database query and has nothing to do with a...

Product: Dataease [{8}]FIVE. Written by DataEase 28/03/20 at 14:26:30

Re:Re:Re:Re:subform MemoEXECDQL

I understood all&nbsp;the explanation.Attached please find a sketch with the problem.I don't get an error message ; the problem is that&nbsp;after clicking the button in the subform, nothing is done ( the DQL code is not executed ) even...

Product: Dataease [{8}]FIVE. Written by afonso santos 28/03/20 at 20:08:46

MemoExecDql running on filtered records

Hi DataEaseI created a form based on a table with some predefined filters on QBM.on a button of the form via OML I launch an update procedure using MemoexecDQL.Here the OML---------------------------------------------------...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 04/07/20 at 09:16:32

Re:MemoExecDql running on filtered records

Hi Marco.Sounds strange. We know that some strange things can happen when you combine OML and ExecDQL.&nbsp;We will try to see if we can replicate the problem and get back to you....

Product: Dataease [{8}]FIVE. Written by DataEase 06/07/20 at 23:21:27

Re:Re:MemoExecDql running on filtered records

Here a test database as requested. Please unzip and open it. Work on VTestMemoDQL and follow the istructions. no userid / password i requested....

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 07/07/20 at 11:30:35

Re:Re:Re:MemoExecDql running on filtered records

Hi again Marco.Sorry for the delay in responding.You have found an old bug that was still there in DE9 too.The problem is that the relationship that is created in memory due to the any statement is cleared together with all the...

Product: Dataease [{8}]FIVE. Written by DataEase 17/07/20 at 13:41:08

MemoExecDQL and Message

Hi all again,I've the code as follows in an DQL :DQL 677"define "act" text .define "imagem" text 30 .define "cod" text 13 .define "msg" number .Msg := message ( concat ( "Atencao! Detectada Producao em...

Product: Dataease [{8}]FIVE. Written by afonso santos 12/12/21 at 11:23:50

Re:MemoExecDQL and Message

One thing I forgot,If we remove the message function, the for and enter&nbsp;sequence are well executed .afonso...

Product: Dataease [{8}]FIVE. Written by afonso santos 12/12/21 at 11:34:38

Re:MemoExecDQL and Message

When I use that message I use it a slightly different way.Instead ofMsg := message </...

Product: Dataease [{8}]FIVE. Written by Paul Cheeseman 15/12/21 at 13:15:31

Re:Re:MemoExecDQL and Message

I just tested it, and it works the same both ways.&nbsp;...

Product: Dataease [{8}]FIVE. Written by Paul Cheeseman 15/12/21 at 13:23:45

On the blog about MemoExecDQL

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.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

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


dg3_HelpView