Simplicty and flexibility!


Command::

end


Parameters


Returns/Result


Examples


Reference

end

Type

Procedural Command

Purpose

The end command marks the end of the span of control of other processing and/or procedural commands.

Syntax

 ACTION 1 .

 ACTION 2 .

 .

 .

 ACTION N .

end

 

Usage

An end command is required following the last specified action invoked by a for, case, if, or while command.

When multiple procedural commands are used in a script, the proper positioning of end commands is critical to correct processing. Each end command refers to the most recent procedural command in the script. Each procedural command controls processing of the script until it reaches its matching end command (see Example 2).

Example 1

for MEMBERS ;

list records

LAST NAME ;

TOTAL DUE .

end

 

This script tells DataEase: Process all the MEMBERS records and list each member's LAST NAME and TOTAL DUE in the report output.

 

Example 2

for MEMBERS ;

if highest of RESERVATIONS DATE < 01/01/99 then

delete records

else

delete records in RESERVATIONS

with ( DATE < 01/01/99)

end

if highest of RESERVATIONS DATE >= 01/01/99 then

list records

LAST NAME in order ;

highest of RESERVATIONS DATE .

end

end

 

This script tells DataEase: (1) For each MEMBERS record, find the most recently dated record in the related RESERVATIONS table, (2) if the most recent reservation is dated before January 1st, 1999, delete the MEMBERS record, (3) if a member's most recent reservation is dated on or after January 1st, 1999, delete all of that member's RESERVATIONS records dated prior to 1999, and (4) for all members with reservations dated on or after January 1st 1999, list the members in order by LAST NAME and show the date of each member's most recent reservation.

Notice that for each if command in the script, there is a corresponding end command. The first end marks the end of the if command that selects which records to delete. The second end marks the end of the if command that selects which records to include in the report output. The third end marks the end of the for command that selects the records from the Primary table.

See Also


On the forum about end

Windows XP Support is Ending Soon

Dear DataEase for DOS Users,If you are still using Windows XP, please keep in mind, support is coming to an end.Here is the link from the Microsoft web site:http:/...

Product: Services. Written by Jeyarajah Arulrajah 20/02/14 at 20:49:26

How to send reports as a PDF format.

Can you help! I am trying to email my invoices and reports using PDF format.Your help will be much appreciated!...

Product: DataEase 6.x. Written by joe peart 09/11/14 at 12:06:34

SendEmail

Have done some tests with the use of "SendEmail" this works well using only an attachment, but when more are admitted will be no email received, Are there opportunities for multiple attachments, if so, how shall command line formulated. Taught...

Product: Dataease [{8}]FIVE. Written by Tor Nerland 13/12/14 at 09:58:09

Re:SendEmail

Simples...You don't add a new -a you simply space the attachments&nbsp;sendemail -f tnerla@broadpark.no ........... -u Test2xx -o message-content-type...

Product: Dataease [{8}]FIVE. Written by DataEase 13/12/14 at 10:52:08

Re:Re:SendEmail

Takk for raskt svar. Mitt neste spørsmål er: Er det noen mulighet for å omgå taket på 255 tegn som DE har ?.Translation for our other deserving users:Thanks for the quick answer.Next question: Is there a way to get aroun...

Product: Dataease [{8}]FIVE. Written by Tor Nerland 13/12/14 at 12:34:57

Re:Re:Re:SendEmail

This is a question that we deliberate over a lot to be honest.The problem is that DE is 8 bit at "heart". This sound crazy and outdated, but in reality it is brilliant, because it means that it is blitzingly&nbsp;fast.With hear we mean...

Product: Dataease [{8}]FIVE. Written by DataEase 13/12/14 at 12:44:08

Re:Re:Re:Re:SendEmail

Adding to the last post, we firstly need to correct the "deliberate error"&nbsp;in which the arguments of the WriteToFile() function appear in reversed order :-)&nbsp; For anyone who is interested, the following coding will generate a .bat file which...

Product: Dataease [{8}]FIVE. Written by Bill Nicholson 02/01/15 at 17:36:04

Re:Re:Re:Re:Re:SendEmail

I am afraid that it is too late to correct the "deliberate error" of the argument order in WriteToFile(). The problem is that it is the complimentary function to MemoWriteToFile() so it has the same argument order. Obviously you are correct, and it sh...

Product: Dataease [{8}]FIVE. Written by DataEase 05/01/15 at 09:14:44

Re:Re:Re:Re:Re:SendEmail

So to the issue at hand here.... and this is a "Can't see the forest for all the threes issue!"The problem is that you call your bat file SendEmail.bat.... so you basically call your own bat file over and over and over and over again instead o...

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

Re:Re:Re:Re:Re:Re:SendEmail

I seem to be particularly slow on this one. As ever when there's a problem one should go back to first principles.I have compiled a file called "testing.bat"&nbsp;with the following commands:ECHO onPAUSE We are now in the bat file...

Product: Dataease [{8}]FIVE. Written by Bill Nicholson 07/01/15 at 16:09:43

Re:Re:Re:Re:Re:Re:Re:SendEmail

You have a "knack" for finding/testing the things that don't work ;-)Sorry, can't help it, just have to wind you up.I did the same as you, and realized that ExecuteFile() will not give you any Console Output i.e. the Bat is run but any...

Product: Dataease [{8}]FIVE. Written by DataEase 07/01/15 at 18:57:26

Re:Re:Re:Re:Re:Re:Re:Re:SendEmail

Look I am just an average Joe trying to develop some applications at DE's outer edge and I keep running up against these problems - I am not looking for them, honest. I created the simple test problem to get the hang of ExecuteFile(), couldn't make it...

Product: Dataease [{8}]FIVE. Written by Bill Nicholson 07/01/15 at 20:36:07

Timeout End session in DataEase

There's a way to end a dataease session after a predetermined time of inactivity&nbsp;? The goal is to save memory and resources. Thanks....

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 12/05/15 at 08:12:41

Re:Timeout End session in DataEase

No. There is currently no independent timer in DataEase.We have plans for creating independent trimer processes that can call functions/actions but it is not close to the top of the list at the moment....

Product: Dataease [{8}]FIVE. Written by DataEase 12/05/15 at 08:23:33

send an email with several recipients

I’m trying to send an email via dataease. Over all this is a very useful function, but my goal is to send an email to many recipients and&nbsp; the “send” command use simply a string with a limitation of 255 characters that don’t fit all the recipient...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 17/08/15 at 09:08:30

Re:send an email with several recipients

It is a problem that functions cannot take longer arguments than 255 in DataEase, but not one that there is any easy way around.Both email functions in DE8.x is "third party" and we have scheduled a built in function for some time but as the t...

Product: Dataease [{8}]FIVE. Written by DataEase 17/08/15 at 11:32:01

Re:Re:send an email with several recipients

Thank you for your reply. I know that it's not an error. I wrote into the forum only for a suggestion. Anyway&nbsp; in the meantime I found an alternative solution. I mean&nbsp;1) Create a .cmd file using the complete syntax of blat command usi...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 17/08/15 at 12:03:16

Re:Re:Re:send an email with several recipients

To be honest, that too was on my mind but for you to come up with is creative and elegant, for me to suggest it sound like we are asking you to make your own product ;-)So you get all the credit ;-)...

Product: Dataease [{8}]FIVE. Written by DataEase 17/08/15 at 12:12:54

SendEmail

Trying to send mail from DataEase using SendEmail here is my script. It creates the batch file but no email received. What haven't I&nbsp;done correctly?define "retval" text .<span style="col...

Product: Dataease [{8}]FIVE. Written by BLESSED SHUMBA 18/09/15 at 13:05:08

Re:SendEmail

Try running the batch file in a command window. &nbsp;That way you should see messages returned by sendemail.exe.RegardsJon...

Product: Dataease [{8}]FIVE. Written by Jon Worthington 18/09/15 at 14:56:05

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

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

Problem changing between Extended and Standard date

I have a date field which I set to Extended but decided after&nbsp;testing a&nbsp;couple of records to change it to Standard, however, when I click the Standard radio button all that happens is the definition window goes blank, if I then click the Typ...

Product: Dataease [{8}]FIVE. Written by Rob Birney 01/03/16 at 12:51:36

Re:Problem changing between Extended and Standard date

There is only one word for this....BUG!The field definition dialogue is unnecessarily over-engineered and as &nbsp;result there is some peculiar behaviour (try to switch to and from Lookup field etc).This problem has been trace...

Product: Dataease [{8}]FIVE. Written by DataEase 01/03/16 at 13:51:00

Problems with Umlauts/Extended Characters in LegEasy4DOS Printing

I am testing LegEasy4DOS and everything works brilliantly except one strange problem. When I print all my umlauts disappear.I have tried everything I can think of but i can't work around it.The strange thing is that the letter is there...

Product: LegEasy DOS. Written by Thomas 03/01/17 at 19:12:31

Re:Problems with Umlauts/Extended Characters in LegEasy4DOS Printing

Hi Thomas. This is simply due to a feature in DataEase for DOS that control how extended characters are to be handled on your printer. Just go to the printe...

Product: LegEasy DOS. Written by DataEase 03/01/17 at 19:27:50

How do you send control strings to HP LaserJet printers. using LegEasy4dos?

How do you send control strings to HP LaserJet printers. using LegEasy4dos?...

Product: LegEasy 4DOS. Written by Bob 16/04/18 at 20:44:03

Re:How do you send control strings to HP LaserJet printers. using LegEasy4dos?

LegEasy4DOS Professional 1.0 support Epson MX80 native as emulation. In 2.0 we will support HPCL or HP Laserjet as well which will cover all practical implementations...

Product: LegEasy 4DOS. Written by DataEase 16/04/18 at 20:46:24

What version of TLS is used by SendEmail?

HiAs of October 31, 2018, Office 365 will no longer support TLS 1.0 and 1.1.&nbsp;ReferencePlease can you confirm which ve...

Product: Dataease [{8}]FIVE. Written by Jon Worthington 26/10/18 at 11:39:02

Re:What version of TLS is used by SendEmail?

SendEmail is a third party software included in DE8 to faciliate sending emails directly from DE8. This feature will be replaced in DE9 with native IMAP/SMTP/POP support for two way email communication.SenEmail.exe is no longer supported by th...

Product: Dataease [{8}]FIVE. Written by DataEase 30/10/18 at 16:17:57

Video/Pictures of DE9 for end-users

Hi. Does anyone have any prt screens or videos of DE9 so I can see how the user-interface looks like. I.e. the view my end-users will se when they use the database (Interface)?Thanks you//Daniel...

Product: . Written by Daniel Kron 09/02/20 at 11:51:30

Re:Video/Pictures of DE9 for end-users

Hi DanielPls find sample menu - Using HTML in DE9 and sample form based all on DE9...

Product: DataEase 9 Developer. Written by Josef Vella 09/02/20 at 18:22:45

reorganise form, DE5 would reorganise records into ascending order, DE8.5 does not. Why?

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Giles Dadd 28/10/20 at 17:25:13

Re:reorganise form, DE5 would reorganise records into ascending order, DE8.5 does not. Why?

Clustering of Data is still possible in DE85 but not recommended. Clustering WILL sort data in order based on the keys set out in the cluster index but as it will not sort new data after you have cluster...

Product: Dataease [{8}]FIVE. Written by DataEase 03/11/20 at 09:27:53

Sending a report to different printers

Hi there, I am using Dataease version 6.57. I have a question: how can I send a report to different printers simultaneously?...

Product: DataEase 6.x. Written by Mohammad AL 29/08/22 at 11:42:57

Re:Sending a report to different printers

In DE6 this is tricky. If my memory don't fail me, there was some CDF's you could use to do this but I'm not sure if they are still available - maybe someone on her can help you.However in DE8 the first thing we introduced was Workstation p...

Product: DataEase 6.x. Written by DataEase 30/08/22 at 11:10:46

On the blog about end

New Function in 8 - MemoMemoCopy() - Copy, Insert or Append a Memo to another (Ver. 8.0.0.1005)

This little function is together with MemoReplace() almost the centrepiece of the Memo Class.As you might have already discovered, normal DataEase functions like Jointext, Firstc, MidC or even Concat, doesn't go very far when it comes to Memo f...

Product: Dataease [{8}]FIVE. Written by DataEase 29/09/11 at 12:32:32

New Function in 8 - MemoCopy() - Copies, Appends, or inserts a field into a Memo (Ver. 8.0.0.1004)

Simple little function that allow you to append, insert or copy a "normal" DataEase field into a Memo field.See MemoMemoCopy() for more information.int MemoCopy(MemoToCopyTo,FieldToCopy,switch) Swtitch: 0=Append 1=Overwrite/copy 2=Insert...

Product: Dataease [{8}]FIVE. Written by DataEase 27/09/11 at 12:40:13

New Function in 8 - WriteToFile() - Write/Append a string(256) to a file. (Ver. 8.0.0.1146)

This function is part of a triumvirate, where the other functions are MemoWriteToFile() and MemoReadFromFile(). This function is complimentary, as it will write the content of a "normal" DataEase field or function to a Text file. Ex. WriteToFil...

Product: Dataease [{8}]FIVE. Written by DataEase 16/10/12 at 16:41:16

New Function in 8 - DatePicker() - Function to pick a date from a calendar

We are currently on the final stretch of DataEase 8 new functionality. One function that a lot of you have been wanting is a date picker. In a momen...

Product: Dataease [{8}]FIVE. Written by DataEase 04/11/12 at 21:58:03

Re:New Function in 8 - MemoCopy() - Copies, Appends, or inserts a field into a Memo (Ver. 8.0.0.1004)

Slight error in the spec: 0=Append 1=Owerwrite 2=Delete 3=Insert at beginning. Sorry!...

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

New Function in 8 - MemoStringFrom() - Copy the tail end of a Memo to a Target Memo (Ver. 8.0.0.1203)

This is the second of a triumvirate of Memo functions that directly correspond to the String(ToFromBetween) functions.MemoStringTo() Copies the content of a memo from the beginning up to SEARCH into a target Memo, and MemoStringFrom() copies t...

Product: Dataease [{8}]FIVE. Written by DataEase 17/01/13 at 17:34:28

Mail send action now handles attachments

The mailsend action module has got a new method named sendmailwithattachments. This method do the same as mailsend, but can also take a list of files as a parameter. Make sure you have DG3 v.0.12.978 or newer.This is how the mailsend act...

Product: DataEase Generation 3. Written by DataEase Development 17/04/13 at 12:40:47

How to send parametes in a chain of redirected pages (simulate the DOS chain menu in DG3)

User that have been using DataEase for a while know that a common problem is that you lock your self out of a table if you try to do things that need a full table lock (delete all) in the same dql that you do updates. To overcome this, we used to use...

Product: DataEase Generation 3. Written by DataEase Development 30/07/13 at 13:22:44

How to extend user with field from a DataEase table in DG3

In the current version of DG3, we use a special table for users and authentication. It is not the table used in DfW, but a completely separate entity to satisfy the need of session and group security on the web. The build in DG3 user table contains...

Product: DataEase Generation 3. Written by DataEase Development 19/11/13 at 19:11: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

DataEase 8.5 and programming vs. DataEasy... (How to use programming to bend the imagefield to your bidding!)

Download Sample!<stron...

Product: Dataease [{8}]FIVE. Written by DataEase 22/06/15 at 11:24:29

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

New functionality in DataEase 8.5 - MoveToFront/SendToBack* (Ver. 8.5.0.2128)

Download sample DataEase for Windows object order and priority has been somewhat of a mystery since...

Product: Dataease [{8}]FIVE. Written by DataEase 21/01/16 at 17:59:26

New Version of 8.5 - Recommended update from 2172!

Typically after the full release of a version you will get some frequent updates to correct bugs discovered by our vigilant users.This versions fixes a serious bug with QBF (Write protected fields could not be searched etc), and a new fix to a...

Product: Dataease [{8}]FIVE. Written by DataEase 17/02/16 at 12:27:01

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


dg3_HelpView