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

Command::

for



Parameters


Returns/Result


Examples


Reference

for

Type

Processing Command

Purpose

The for command is used in a script to specify the table from which records are selected for processing and the criteria used to select those records.

Usage

The for command is the most frequently used word in the DataEase Query Language. Most Processing procedures begin with this command.

A script can have multiple for commands when records must be selected from different tables (see Examples 1 and 2). for commands can be nested to alter the sequence of program actions (see Example 3).

The for command is always terminated by an end command. Actions specified between a for command and its corresponding end command are executed once for each record selected by the for command.

Syntax

for TABLENAME|RELATIONSHIP

 [named "UNIQUE RELATIONSHIP NAME" ]

 [with ( selection criteria) ] ;

 

The for command usually requires a semicolon after the TABLENAME (and selection criteria, if any). However, when a for command is nested within another for command, only the outermost for command requires a semicolon (see Example 3).

Example 1

Example 1 shows how to use a for command to access a single table.

for MEMBERS with TOTAL DUE > 175 ;

list records

LAST NAME in order ;

TOTAL DUE .

end

 

This script tells DataEase: (1) Select the MEMBERS records that have a value greater than $175 in the TOTAL DUE field, and (2) for each selected record, list the member's LAST NAME and TOTAL DUE. The output from this script, arranged in alphabetical order by LAST NAME, might look like this:

 

 

Last Name

Total Due

Christino

280.00

Perrault

215.00

Stafford

185.00

Strachan

205.00

 

Example 2

Example 2 shows how to use sequential for commands without nesting.

for MEMBERS with TOTAL DUE > 200 ;

list records

LASTNAME in order .

end

 

for RESERVATIONS ;

list records

LASTNAME in order ;

RESERVATION I D ;

TOTAL DUE .

end

 

This script tells DataEase: (1) Select the MEMBERS records that have a value greater than $200 in the TOTAL DUE field, (2) for each selected record, list the member's LAST NAME, (3) select all the RESERVATIONS records, and (4) for each RESERVATIONS record, list the LAST NAME, RESERVATION ID and TOTAL DUE.

When a script contains two or more for statements that list records, DataEase prints or displays all records requested by the first for statement first, then displays all records requested by the second for statement, and so on. The output for the script in Example 2 might look like this:

 

Last Name

Christino

Perrault

Stafford

Strachan

 

 

Last Name

Reservation ID

Total Due

...

...

...

Christenson

00011

3,360.00

Christino

00139

5,450.00

Christino

00259

4,570.00

Christino

00765

6,490.00

Chu

00113

2,780.00

Chu Cipriano

00541

3,480.00

Clark

00052

2,660.00

...

00194

6,290.00

 

...

...

Example 3

Example 3 shows how to use nested for commands.

Although you can display data from multiple tables using sequenced for statements, as shown in Example 2, a script may run faster and generate more useful output when it contains nested for statements as shown in Example 3:

for MEMBERS with TOTAL DUE > 200 ;

for RESERVATIONS

list records

MEMBERS LAST NAME in groups ;

RESERVATIONID in order ;

TOTAL DUE .

end

end

 

In this script, the second for command, which is nested within the first, selects all RESERVATIONS records related to the selected MEMBERS records. For each of those RESERVATIONS records, DataEase performs all the actions between the second for and its corresponding end.

This query tells DataEase: (1) Select the MEMBERS records that have a value greater than $200 in the TOTAL DUE field, (2) find all the related RESERVATIONS records for each MEMBERS record selected in Step 1, (3) for each selected MEMBERS record, list the member's LAST NAME, and (4) for each selected RESERVATIONS record, list the RESERVATION ID and the TOTAL DUE.

Notice that in Example3, there is no semicolon after the second for because it is nested within another for command. In contrast, both for statements in Example 2 require a semicolon because neither statement is nested inside another for statement. The output from this script, arranged in alphabetical order by LAST NAME, might look as shown on the next page.

 

 

Last Name

Reservation ID

Total Due

Christino

00139

5,450.00

 

00259

4,570.00

 

00765

6,490.00

Perrault

00150

2,900.00

 

00445

2,790.00

 

00671

3,010.00

Stafford

00098

5,712.00

Strachan

00044

3,740.00

 

00337

4,120.00

 

The in groups operator tells DataEase to processes all the records for each member together as a group and to list the members in alphabetical order. The in order operator tells DataEase to arrange the data for each member in ascending order by RESERVATION ID.

Note: The in groups operator always precedes the in order operator in a script.

See Also


On the forum about for

Re:Welcome to the new DataEase Forum

[@EOF@]...

Product: Not product specific.. Written by diego fernando ocampo gomez 10/09/12 at 15:37:38

Re:Welcome to the new DataEase Forum

I am just showing this functionality to a potential customer....

Product: Not product specific.. Written by DataEase 17/09/12 at 15:47:34

Forum createt in Dataease

Hallo together, i have read that this Forum was createt in Dataease. Can i get more Information how to do that and what kind of Software i need? I am using since 15 years Dataease but not in connection with the Internet ( like Internetshop or Internetfo...

Product: DataEase Generation 3. Written by Markus 18/09/12 at 06:27:51

Re:Forum createt in Dataease

Dear Markus. Thank you for taking the time to write to us. This entire website is developed in DG3 Web Framework, which is the first product in the new DG3 product line. It is still an Alpha product, which means that it is still in Development and tha...

Product: DataEase Generation 3. Written by DataEase 20/09/12 at 16:35:52

Re:Welcome to the new DataEase Forum

Dear DataEase Users. We have yet again updated the user forum, and we will continue improving it "DataEase style" as things progress. At the moment the activity is not higher than it merits us showing all the threads in the opening view, as things prog...

Product: Not product specific.. Written by DataEase 22/09/12 at 10:56:35

Error when opening DataEase 6.1 for DOS on Windows 7

I get the following error message when I try to open DataEase.Exe file: procedure entry point @DE_VOBJECT@getPrintFlags$qv could not be located in devobj.dll Any help would be appreciated....

Product: Not product specific.. Written by Aniz Asaria 16/10/12 at 18:15:25

Re:Error when opening DataEase 6.1 for DOS on Windows 7

DataEase 6 is not Windows 7 compatible, and this is why we have created LegEasy 6 Windows (6.53). Upgrading from 6.x to 6.53 cost only £99 pr user, and you can buy it online on the shop. http://www.dataease.com/dg3_Shop/?CartOwner=ulrik@nefines.com&fie...

Product: Not product specific.. Written by DataEase 17/10/12 at 08:24:27

Re:Error when opening DataEase 6.1 for DOS on Windows 7

Buying LegEasy is the best option. You can however use Windows XP mode if you have Windows 7 Professional or Ultimate (Follow the instructions on the Microsoft site). There are down sides to it though, it will use a chunk of your hard drive and will ta...

Product: Not product specific.. Written by Rob Birney 17/10/12 at 19:25:48

Interface functions and forms

I have long worked with DataEase Windows from version 6.52 to version 7.2.947, and I saw a flaw in the handling of forms and versions that can not be given options for buttons Minimize, Close, for disable power as in almost all the other programming tool...

Product: DataEase for Windows 7.x. Written by wilmer raul contreras riaño 30/10/12 at 14:48:22

Re:Interface functions and forms

Hi again Wilmer. "DataEase for Windows gives and it taketh away..." It is not a development tool, but an RAD framework. You get a lot very quickly if you play along with it, but if you want everything to work exactly the way you want it, you spend a lot...

Product: DataEase for Windows 7.x. Written by DataEase 30/10/12 at 18:12:36

DataEase for DOS and a way forward?

Good Morning We currently have a 7.2 licence, and have lost track of where things are at. I keep revisiting DataEase site with the hope that the promise finally eventuates, and reading the content on this site at the moment, indeed the future looks pro...

Product: LegEasy DOS. Written by David Packenas 15/11/12 at 15:23:27

Re:DataEase for DOS and a way forward?

Hi David. Glad I caught you. LegEasy is basically a "group name" or product line, for products that we make to help customers that are "stuck" in older versions of DataEase. I am an old DFD "dog" myself and for us it is easy to forget/believe that Da...

Product: LegEasy DOS. Written by DataEase 15/11/12 at 15:27:53

Re:DataEase for DOS and a way forward?

I concur. 4.53 still can be very competitive you need things done in a fast way. In my company I am using DE since 1987 (yep Datamaster you recall) We even went up to the Datamaster UK headquarters in the old days to convince there were some calculation...

Product: LegEasy DOS. Written by Stefan Weckx 26/11/12 at 19:13:06

Re:Re:DataEase for DOS and a way forward?

Dear DataEase, I too would very much like to be involved in DataEase LegEasy for Dos and DG3. I have been in previous communication with Ulrik about our site and my 25 years experience of DataEase as a programmer and IT Support person. I've used DataE...

Product: LegEasy DOS. Written by Lee Oatway (Urban Vision) 03/12/12 at 07:57:12

Viable migration for Dataease 4.53?

So it looks like there is and might not ever be a viable way to migrate my dataease 4.53 applications to windows based products with out virtually re writing the entire applications?...

Product: LegEasy DOS. Written by Robert Beer 20/12/12 at 15:18:48

Re:Viable migration for Dataease 4.53?

DataEase DOS is just put on hold until we find out if there is a market willing to pay for it out there.The sad truth is that this product should have been there 20 years ago and it can now look like the train have left the station.We...

Product: LegEasy DOS. Written by DataEase Development 20/12/12 at 18:17:44

Re:Viable migration for Dataease 4.53?

In my opinion migrating a DOS app to a Window app is a mistake.....unfortunately been there, done that...sufferred consequences :(DOS is not Windows and Windows is not DOS.  Things are done differently.  So my advise, stock take your...

Product: LegEasy DOS. Written by Josef Vella 21/12/12 at 16:04:27

DE8 3 for 1 Offer Confused...

I am a little confused. It says on the add - This weekend only. Does this mean the upcoming weekend or the weekend just passed? Peter...

Product: Dataease [{8}]FIVE. Written by DroopyPete 21/01/13 at 16:33:38

Re:DE8 3 for 1 Offer Confused...

Hi Peter!It is the weekend past and today until Midnight i.e. the 21st!...

Product: Dataease [{8}]FIVE. Written by DataEase Sales 21/01/13 at 16:40:13

Converting up my DataEase 5.16 for DOS

What steps do I need to convert up my DataEase 5.16 for DOS apps to a version that will run under Windows7?  ...

Product: LegEasy DOS. Written by IDPH 07/03/13 at 21:28:41

Re:Converting up my DataEase 5.16 for DOS

I am running 5.53 Dos on Windows 7, but it will only run on a 32 bit system, not 64 and now seem to be is wobbling everytime Microsoft do an automatic update....

Product: LegEasy DOS. Written by Graham Brown 12/03/13 at 14:18:29

Opening a Sub Form from a Field Objact

How do i set up within a form so that when entering the correct information in a field it will then open up automatically the related sub form?...

Product: Dataease [{8}]FIVE. Written by Graham Brown 12/03/13 at 14:21:00

deleted form but table still there

Hi againI have had some trouble with forms, so I deleted them but the table did not delete. Can I delete the table?Thanks...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 08/05/13 at 02:16:57

Re:deleted form but table still there

If you have a tricky table like this you need to do the following:1. Create a new form on top of the table.2. Go to Document Properties and check "Defines Table".3. Save the Form.4. Delete the form and answer yes when it ask if &nb...

Product: Dataease [{8}]FIVE. Written by DataEase Customer Support 08/05/13 at 10:25:35

Re:Re:deleted form but table still there

Thanks for the tip but no luck here.when I select the table to create new form I get error message "table file VARTAAB.DBA not found -1"and another table with no form error message " Error 712 Adding Form. Table not found."any fur...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 08/05/13 at 20:33:49

Re:Re:Re:deleted form but table still there

Works in dataease 7.2 so try this:Create a new DQL:delete table "Temp form 56". --replace with name of your tableRun this and job done....

Product: Dataease [{8}]FIVE. Written by Simon B 09/05/13 at 09:13:46

Stretching the limits? DataEase for Dos v5.16 on Windows 7 32bit

Hi, I do realise I am stretching the limits here. I am running a vintage DataEase for Dos app on v5.16 which has run very successfully on WinXP. However, since upgrading some workstations to Win7, am having frequent crashes and "index inconsistent" er...

Product: . Written by Wendy Parker 09/05/13 at 11:37:15

Re:Stretching the limits? DataEase for Dos v5.16 on Windows 7 32bit

Hi Wendy.You have stretched the limit as far as it will go (almost...;-) as Windows 7 x32 is as far as we know the furthest you can go with DFD.However it shouldn't work any worse in Windows 7 x32 than it do in XP so the problem is not...

Product: LegEasy DOS. Written by DataEase Support 09/05/13 at 12:24:04

Forgotten Username and Password

[@EOF@]...

Product: DataEase 6.x. Written by Richard Grant 09/05/13 at 19:50:42

Re:Forgotten Username and Password

I last used my Dataease 10 years ago. I have reason to get back into it but have forgotten Username and Password. Is there a way to find what I used then to access my Dataease?? Thanks....

Product: DataEase 6.x. Written by Richard Grant 09/05/13 at 19:52:48

Re:deleted form but table still there

Thank You worked a treat....

Product: Dataease [{8}]FIVE. Written by Gregor Popp 09/05/13 at 23:19:08

Re:Re:Re:Re:deleted form but table still there

It is always nice when the community step up where we fail to help.It is always nice to be reminded that things are not always as they seem in DataEase.Why would delete table work in DQL when it doesn't work in the Catalog?<...

Product: Dataease [{8}]FIVE. Written by DataEase 10/05/13 at 06:59:44

Re:Re:Forgotten Username and Password

Hi!Obviously we can't publish methods of breaking into DataEase databases online, but we obviously have methods to unlock any DataEase app if need be.This is a service that we offer and it cost £49&nbsp;If you want to proceed...

Product: DataEase 6.x. Written by DataEase Support 10/05/13 at 06:34:39

Opening specific form and auto fill

1. How do I open a specific record in a new window from the main form. For-exampl a specific invoice from a list of invoices for a customer? 2. How to open a form in a new window to add a child rec...

Product: Dataease [{8}]FIVE. Written by Ilya 10/07/13 at 11:06:38

Re:Opening specific form and auto fill

ff...

Product: Dataease [{8}]FIVE. Written by Graham Brown 17/07/13 at 09:36:09

DatePicker() in subforms...?

Here is a challenge for you. See the attached image. How do we use datepicker for each row ?................................................................................. ............................................

Product: Dataease [{8}]FIVE. Written by Arul 24/07/13 at 09:51:54

Re:DatePicker() in subforms...?

Download SampleThe best way of doing this is by building our own "control". in DE8 you can manipulate objects by number. i SetValue("Date...

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

Converting LineFeed in text to <br> for use in CMS.

I have a challenge. I import text into a DE system for editing in Memo and then I am re-exporting it for use in a CMS system.The problem is that the Memo field use traditional ASCII(10) ASCII(13) for Line Feed, but the CMS expect &lt;br&gt;<br...

Product: Dataease [{8}]FIVE. Written by Henk 29/07/13 at 14:00:39

Re:Converting LineFeed in text to <br> for use in CMS.

Yes, this is easy. We used the same approach in our first Email client (pre. HTML editor).If the CMS had been designed in DG3 you would simply use a filter |linebreaksbr ex. [{mymemo|linebreaksbr}] would automatically convert old style line fe...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Support 29/07/13 at 14:03:03

Re:Converting up my DataEase 5.16 for DOS

Install VirtualBox and then WindowsXP within the virtual machine. &nbsp;Works fine....

Product: LegEasy DOS. Written by Earl Wertheimer 08/08/13 at 07:03:23

Searching in the Forum

We have now enabled the search function in the Forum. For now it is only limited to searching the Topic, but we will also implement an advanced search so on can search anywhere in the Forum.Eventually you will get a global search for the entir...

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

Forum structure

I can see that the forum is obviously a database in the backround. I can see also that as each topic is added a new entry is made. Sometime if we are lucky someone will reply or add to an existing...

Product: Dataease [{8}]FIVE. Written by Kensington 20/08/13 at 17:01:06

going to related record from one form to another

I am trying to create a button that takes me from Form1 to a related record in Form2, I have tried the FormOpenRelated(Form2) function. But this does not exactly do what I want. This does take me to the related record in the form. ...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 26/08/13 at 06:40:51

Re:going to related record from one form to another

It makes sense, but it is not how searching works in DFW. In DFD you search up the first matching record in a query and you could then go Next, Previous from there or go to the next matching record. In DFW it is designed to ret...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 26/08/13 at 12:00:19

Re:Re:going to related record from one form to another

A sample would be great, this is not about sorting but comparing results when we change data in form1 to the form2 ...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 26/08/13 at 20:05:38

Re:Re:Re:going to related record from one form to another

Ion. If you send us a small app which illustrate what you want to do, we will amend it to solve the problem. As it stands now, I don't think we really get what you are trying to do ;-) Send it to techsup@dataease.com...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 28/08/13 at 12:34:43

Document Properties - Clear Form after entering a record

When entering a record via a form, it is useful to be able to "Clear form after entering a record". Equally useful is the option to Confirm changes. Whilst I can get "Clear form" to work, I cannot get the confirm changes to pop up. Is it...

Product: Dataease [{8}]FIVE. Written by Kensington 03/09/13 at 12:36:53

Re:Document Properties - Clear Form after entering a record

Further to my comment above re Confirm Changes option, I have discovered that it does work if you first go to a related file by pressing F10 and ( without entering anything ) close it and then return to the main form and press F4. In this case DE8...

Product: Dataease [{8}]FIVE. Written by Kensington 03/09/13 at 14:18:06

Create a PDF file using fields in a form as the file name

Hi Is it possible to create a pdf file using some of the fields in the form as part of the file name with print document any ideas ...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 10/09/13 at 04:54:10

Re:Create a PDF file using fields in a form as the file name

Download Sample Yes! We made a small sample to show how to do this some time back, but I think it was so long ago that it was not published on this forum.....

Product: Dataease [{8}]FIVE. Written by DataEase 10/09/13 at 07:40:46

Re:Re:Create a PDF file using fields in a form as the file name

Great works a treat, thank you ...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 11/09/13 at 09:31:40

Generate an email from a form

Hi, I use a DE8 to keep an overview of several projects. In my form i have among other fields a field for numbering the project, the project name, a date field and email address for the projectleader. What I want to do; when the...

Product: Dataease [{8}]FIVE. Written by Per Bruvold 02/10/13 at 07:19:36

Re:Generate an email from a form

In DataEase 8 you have a new Email function called Send. It is based on the Blat Library for sending both simple and advanced emails (HMLT formatted with attachemnt/crypting etc). You can read about it here: <a href="http://www...

Product: Dataease [{8}]FIVE. Written by DataEase 02/10/13 at 08:47:50

Deleting particular record(s) from a sub-form

In a form with sub-form (for-example order/order lines) I want to delete lines in the sub-form. I have added a button on the sub-form lines with Action "Record Delete". However when you choose this it asks what do you want to delete, main form or su...

Product: Dataease [{8}]FIVE. Written by Kensington 02/10/13 at 12:42:41

FORUM corrections

It would be nice for the Writer of a Forum entry to be able to correct Forum entries for Typos and spelling mistakes, as there is no preview of what is going to be saved ...

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

Re:Deleting particular record(s) from a sub-form

Anyone there??? ...

Product: Dataease [{8}]FIVE. Written by Kensington 03/10/13 at 14:25:53

Re:Deleting particular record(s) from a sub-form

Hi Place a button on the sub-form. Button Action: Execute Function / Derivation Function: RecordDelete() + Keystrokes(" S_tab_enter") + RecordSave() 1. RecordDelete ....deletes the record 2...

Product: Dataease [{8}]FIVE. Written by Josef Vella 03/10/13 at 15:21:33

Re:Re:Deleting particular record(s) from a sub-form

Thanks for the reply. RecordDelete() + Keystrokes(" S_tab_enter") + RecordSave() Gives an error saying "invalid keystrock _tab_enter" I have tried changing it to RecordDelete() +Keystrokes(" S(_tab)(_enter)") + RecordSa...

Product: Dataease [{8}]FIVE. Written by Kensington 03/10/13 at 16:00:35

Re:Re:Re:Deleting particular record(s) from a sub-form

Hi, Instead of Keystrokes(" S_tab_enter"), you should use Keystrokes("S _enter"). (put a space between S and _enter). So the function should be: Record...

Product: Dataease [{8}]FIVE. Written by Surjo 04/10/13 at 02:34:29

Re:Re:Re:Re:Deleting particular record(s) from a sub-form

Hi all Surjo that works really great , I still have one more annoying item.. as we fill in the data of the subform tabbing across, the user inadvertently presses the delete button, the pause and question "do you want to delete" c...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 06/10/13 at 21:28:15

Re:Re:Re:Re:Deleting particular record(s) from a sub-form

When I try to execute the expression I get the following error message: I think the Message() function is generating the error. ...

Product: Dataease [{8}]FIVE. Written by Kensington 07/10/13 at 12:00:00

More on delete button to subform

Hi all Surjo that works really great(previous thread by Kingston) , I still have one more annoying item.. as we fill in the data of the subform tabbing across, the user inadvertently presses the delete button, the pause and quest...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 08/10/13 at 21:47:24

Re:More on delete button to subform

Download Sample We have just tested tab order in Sub forms and it works, but is the problem that it doesn't skip the Delete button altogether? <...

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

Re:Re:Re:Re:Re:Deleting particular record(s) from a sub-form

Anyone there??? ...

Product: Dataease [{8}]FIVE. Written by Kensington 10/10/13 at 09:26:13

Re:Re:Re:Re:Re:Re:Deleting particular record(s) from a sub-form

Have you checked that the CDFS are defined in you app? Try to put the formula in a field derivation instead, then you will be able to debug by removing bits and see when it is accepted. ...

Product: Dataease [{8}]FIVE. Written by DataEase 10/10/13 at 09:48:28

Re:Re:Re:Re:Re:Deleting particular record(s) from a sub-form

Hi What you need is an event, that when click enter on the data-entry field it will automatically move you to the next line of the sub form. This can be achieved by setting an OML with Keystrokes (_Tab).....so what happens it wil...

Product: Services. Written by Josef Vella 10/10/13 at 10:31:19

Re:Re:Re:Re:Re:Re:Re:Deleting particular record(s) from a sub-form

Message function is there but looking at it has wrong number of arguments! Do you think I need to re-install Dataease? ...

Product: Dataease [{8}]FIVE. Written by Kensington 10/10/13 at 10:59:10

Re:Re:Re:Re:Re:Re:Re:Re:Deleting particular record(s) from a sub-form

The CDF definition is in the application so Re-installing DataEase won't help. Just fill in the correct information in the CDF record. Cunftion Name: Message Description: Custom Message Dialog &amp; Processing<b...

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

Tables and Forms in DataEase for Windows - An interesting article

This is an interesting article in which Lawrence Fox discusses separating separate table creation and management from the user interface in DfW. http://computerwiz...

Product: Not product specific.. Written by Kensington 21/10/13 at 16:02:52

Re:Tables and Forms in DataEase for Windows - An interesting article

In DG3 you will be able to have different business logic i.e. TDF files on the same dataset. So the virtualisation will go one step further. You will also be able to build a TDF over several tables i.e. view. You can as...

Product: Not product specific.. Written by DataEase 23/10/13 at 18:36:54

“Print Procedure” “Print Form Definition”

HiThanks for the update.Is there an option to “Print Procedure” “Print Form Definition” it was an option I used regularly on the old system.Graham...

Product: Dataease [{8}]FIVE. Written by Graham 12/11/13 at 13:45:08

Re:?Print Procedure? ?Print Form Definition?

There is no actions/functions for printing definitions. This too is one place where DFW always have been weaker than DFD…..There is a Print Definition thing on the Print Dialogue, but it doesn’t work and when it did it produced just...

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

Re:?Print Procedure? ?Print Form Definition?

There is no actions/functions for printing definitions. This too is one place where DFW always have been weaker than DFD…..There is a Print Definition thing on the Print Dialogue, but it doesn’t work and when it did it produced just...

Product: Dataease [{8}]FIVE. Written by DataEase 13/11/13 at 10:30:45

SetState for Text Box

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Graham Brown 25/11/13 at 19:44:01

Greyed out form fields

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by 10/12/13 at 14:20:43

Re:Greyed out form fields

Download Sample No username/password. Simply hit OK on login box. We need to guess here, but I would think this is about d...

Product: Dataease [{8}]FIVE. Written by DataEase 11/12/13 at 19:08:35

How to create "dummy" records for export

Hi there,I am a new forum user and this is my very first post, so, in the first place, hail to everybody.I am trying to export to a txt file the order placed by every customer in the past year, grouped by months. I succeeded in grouping...

Product: DataEase for Windows 7.x. Written by George Washington 12/12/13 at 13:15:22

Re:How to create "dummy" records for export

If this is DataEase 7 there is fewer alternatives than in 8 but still possible ;-)I will concentrate on the brute force and you can do the details of exporting it yourself.define temp "january" number .define temp "februay" number...

Product: DataEase for Windows 7.x. Written by DataEase 13/12/13 at 06:39:05

Re:Re:How to create "dummy" records for export

Hi Mr. DataEase and thank you for answering.I tried a modified version of your solution (I have added an additional selection criterion on the customer: without that it gives me the same total for each customer) and it has some problems. The fi...

Product: DataEase for Windows 7.x. Written by George Washington 13/12/13 at 08:45:38

Re:Re:Re:How to create "dummy" records for export

Hi Again.The alternative is to create a nested DQL where you run a For inside a for, and then the second one is nesting a table where you have only one record for each month.for MyData ;for MyMonths ;list recordsSum of MySa...

Product: DataEase for Windows 7.x. Written by DataEase 17/12/13 at 11:24:12

Re:Re:Re:Re:How to create "dummy" records for export

That's smart, a sort of join with another table, thank you now it works....

Product: DataEase for Windows 7.x. Written by George Washington 19/12/13 at 12:00:19

While current status not = 1 do. Will not open input form

I am trying to open a form & post information from that form to other forms using the following, however DE8 will not open the form. If i remove the "while current....&nbsp;do .&nbsp;" the form "Deposit Close_Retrurn" will not open!while curren...

Product: Dataease [{8}]FIVE. Written by Graham Brown 02/02/14 at 10:50:34

Re:While current status not = 1 do. Will not open input form

We just tested this in 8.1.1.1450 (shouldn't be any difference to any previous versions of DE8) and it worked fine. Obviously we didn't test your app as we don't have it, but a input using in general: <span style="color: r...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 03/02/14 at 08:57:00

Re:Re:While current status not = 1 do. Will not open input form

I have looked at the database in question and have found the following:-Problem 1: The table of the form that was the subject of the input using statement was duplicated - I deleted the duplicate in the manner suggested in a recent Forum postin...

Product: Dataease [{8}]FIVE. Written by Peter Birney 03/02/14 at 11:31:26

Re:Re:Re:While current status not = 1 do. Will not open input form

This simple DQL does not display any messages.&nbsp; When run in Design View the flashing cursor disappears.define "pob" Number .pob := 0 .while pob &lt; 5 do .message pob window .pob := pob + 1 .end .message "The...

Product: Dataease [{8}]FIVE. Written by Peter Birney 04/02/14 at 07:59:18

Re:Re:Re:Re:While current status not = 1 do. Will not open input form

Hi! We have just tested this while loop in 6.53 7.2 and 8.1 and it works fine.There must be something "environmental" here that impacts this. Is this in a fresh app or is it in the app that had problems with the while loop earlier?&nbsp;<b...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 04/02/14 at 10:04:40

Re:Re:Re:Re:Re:While current status not = 1 do. Will not open input form

Hi - It works fine in a new app - I will ask Graham if he will let you have a copy of his database (It may still have the duplicate Table Name).Can you advise us where to send it?...

Product: Dataease [{8}]FIVE. Written by Peter Birney 04/02/14 at 10:21:41

Re:Re:Re:Re:Re:Re:While current status not = 1 do. Will not open input form

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Graham Brown 05/02/14 at 14:58:33

Import form a DataEase table

I'm testing the new version of DataEase 8.1.0.1464 and I don't find the possibility to import a dataease table (.DBM) into a destination table inside my database. How can i do ? I used this function very often in the previous version of dataease. Than...

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

DataEase for DOS 4.53 Locking

I am writing this as a knowledge sharing exercise.I was working with one customer on setting up DataEase for DOS 4.53 in MS Windows environment. Windows 2003 server and Windows XP workstations. Reason for this, their Novell server crashed and t...

Product: DataEase for Windows 5.x and before.... Written by Jeyarajah Arulrajah 20/02/14 at 20:40:16

Manual DataEase 8 - printable format -

Where I can find : User's Guide, Designer's Guide, DQL Guide and OML Guide for DataEase 8 in printable version (e.g PDF)? There's only an help on line but I need to view/print all the documentation....

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 12/03/14 at 07:33:05

Problems when I try to install a table within including data for a table

There are serious problems when you try to install a table from another database (same version 8) checking including data for Table. The installation ends normally but when I try to open the table installed, DataEase crashes and ends with an Access Vi...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 27/03/14 at 14:52:31

Re:Problems when I try to install a table within including data for a table

The problem is Locking.&nbsp;In DE7 and DE8 you can run a Local version of DE with Locking and this is enabled by default in DE8.To be able to install a Table with Data you need to run DE as standalone. The best way to do this is simpl...

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

Printing out of form

Printing a record of a form, for example "Customer" with several subforms, is done with a button calling up the procedure. The procedure contains a data input form where you have to put in the customer number and the following procedure script :<p...

Product: DataEase for Windows 7.x. Written by gg.stemper@t-online.de 31/03/14 at 10:14:34

Re:Printing out of form

Hi&nbsp;Guenther!Here there will be several distinctive differences between DE8 and DE7.&nbsp;In DE8 you could do this via the internal functions SetVar()/GetVar() but in DE7 you will need to use either the CDF Set/GetArray() or Set/Ge...

Product: DataEase for Windows 7.x. Written by DataEase Tech Sup 31/03/14 at 11:23:49

Re:Import form a DataEase table

What version? &nbsp;v8.1 has it....

Product: Dataease [{8}]FIVE. Written by Josef Vella 31/03/14 at 16:15:13

Re:Import form a DataEase table

It was removed with all other outdated import definitions in 8.1 and then re-implemented in 1487 and will be further updated in a later version of 8.11487 - 20.02.14 - Update! Exciting new properties added to GetCurrent() - RecordNumber and Row...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup. 31/03/14 at 18:47:51

Re:Manual DataEase 8 - printable format -

Have you any news about my previous request?&nbsp;Thanks....

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

Re:Re:Manual DataEase 8 - printable format -

The Documentation for 8.0 and 8.1 is generated in a DE8.x application. This application will be added as a sample app to DE 8.x and will include the ability to generated a printable documentation....

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

Field derivation formula help, please?

I am trying to sum a number field (days) that first looks up a date field (Date From) in the current form to see if it is greater than another date field (dateToVacSick) in a related form (vd) but I'm having an issue with dataease accepting the deriva...

Product: LegEasy 6 Windows. Written by www.bettersearchllc.com 08/04/14 at 18:12:30

On the blog about for

New Function in 8 - CHR() returns ASCII value for number. Long in comming.... (Ver 8.0.0.1143)

We continue to extend the function library in 8, and one functions that has been missing for "ever", has been CHR. It might be a programmers function, but after we introduced the new exciting Memo manipulation class the lack of this function become eve...

Product: Dataease [{8}]FIVE. Written by DataEase 11/10/12 at 07:07:45

New Function in 8 - UniqueID() - Returns a "Random" Unique ID as Key for a Record (Ver 8.0.0.1139)

One of the most popular and frustrating functions or should we rather say functionalities in DataEase is "Sequence from". Basically this is a "guaranteed" sequence number, and it is great when you need records to be in sequence and have a unique number....

Product: Dataease [{8}]FIVE. Written by DataEase 01/10/12 at 07:42:05

New Function in 8 - FormRefresh() - Refresh form so all active objects are displayed correctly... (Ver. 8.0.0.1132)

This is obviously an unnecessary function but we have created it anyway...;-)DataEase 7.x or aka. the "Flasher from Romford", was flashing and blinking like mad. Every time you moved from one field to the next, it looked like it was going to ha...

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

New Functionality in 8 - HTMLEdit - Rich Text object for editing formatted text in Memo (Ver. 8.0.0.1069)

At some stage DataEase development went "stale". We have seen the same happen to a lot of other companies, and recently to Nokia. They lose their way, and desperately start clinging to the past or go "retro".When I first started working...

Product: Dataease [{8}]FIVE. Written by DataEase 23/04/12 at 09:26:01

New Functionality in 8 - Advanced WebFields - This is the webfield for plugins, Ajax, Java etc (Ver. 8.0.0.1104)

The normal WebField has been with us for several months by now, but we are still learning.The "normal" WebField is built directly on top of a Memo field. This is very effective, but it has its limitations. A "normal" WebPage is reference...

Product: Dataease [{8}]FIVE. Written by DataEase 10/07/12 at 10:09:38

Re:New Function in 8 - UniqueID() - Returns a "Random" Unique ID as Key for a Record (Ver 8.0.0.1139)

Am I right in stating that this function replaces the Set/Get Uneek CDF? And is it right to assume that this unique id can be used to retreive records etc? thanks...

Product: Dataease [{8}]FIVE. Written by Josef Vella 11/10/12 at 12:39:01

Re:Re:New Function in 8 - UniqueID() - Returns a "Random" Unique ID as Key for a Record (Ver 8.0.0.1139)

Hi! This is simply a function that genearte a "guaranteed" unique ID that one can use as one please, but the short answer to the question is... Yes! In PRISM 9, and ID like this will be an integral part of the database design, but till then you will ne...

Product: Dataease [{8}]FIVE. Written by DataEase 11/10/12 at 12:49:33

Re:New Function in 8 - CHR() returns ASCII value for number. Long in comming.... (Ver 8.0.0.1143)

To be honest, there is two things I have been struggling with finding (I just thought it was down to me being stupid and bad documentation), and that is how to insert extended character and how to get "" around texts. I am glad that it wasn't me being...

Product: Dataease [{8}]FIVE. Written by David Mills 01/11/12 at 16:25:44

Re:New Functionality in 8 - Advanced WebFields - This is the webfield for plugins, Ajax, Java etc (Ver. 8.0.0.1104)

Woaw! This means that we can now create advanced web forms in DataEase for Windows?...

Product: Dataease [{8}]FIVE. Written by David Mills 01/11/12 at 16:27:32

Support DataEase 8 - How to improve Web Performance in Web Object from IE7 to IE9 (Or IE10 on Windows 8)

We get some feedback from our DataEase 8 "test pilots" that the Web Object in DataEase 8 doesn't handle things exactly as they want. In DataEase 8 we use the internal IE object for all Web Representation. This object is a little "tricky" to put it mildl...

Product: Dataease [{8}]FIVE. Written by DataEase 18/01/13 at 21:18:19

New Function in 8 - DatePicker() - Use Windows DatePicker to select a date for a date field (Ver. 8.0.0.1180)

No rest for the wicked. Our team of developers consists of Russians, Norwegians, Egyptians and British individuals. It turns out that when the rest of the world fight race and religious wars, we in the engineering and technical businesses only reap th...

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

DataEase 8 Solution/Example - Browse for image and set image field for preview.

We will soon launch our solution database, but nothing wrong with a "preview" of what it is all about.A customer had problems with attaching images to a customer profile in 8 so we just made this solution to help the situation.It is ra...

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

DataEase 8 Default Template - Document Editor with Mail Merging and Formatted Printing (Ver. 8.0.0.1230)

The Default Template in DataEase 8 Pre-Release has been updated with a small example that show how you can build documents with Memo functions, Merge in field information, edit the document in WYSIWYG editor and finally print document properly formatt...

Product: Dataease [{8}]FIVE. Written by DataEase 22/02/13 at 10:03:19

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 - New Functionality - Mouse Wheel now works in Forms/Reports (Ver. 8.0.0.1247)

The work to make DataEase for Windows a "contemporary" product continues. One of the latest updates is that you will now be able to use the Mouse Wheel to scroll up and down in DataEase forms.We will also add this to Memo fields....

Product: Dataease [{8}]FIVE. Written by DataEase 18/03/13 at 09:31:38

How the use querystring to for set the file name for a csv transfer

A transfer can be used for creating an export from a DateEase table. To be able to make the file name for the export in runtime, you can do the following:Create a new transfer and give it a nameSelect source: Current app and a tab...

Product: DataEase Generation 3. Written by DG3 Development 19/04/13 at 14:04:47

New Sample - How to create a text or HTML file for printing in DataEase 8 (Ver. 8.0.0.1308)

Download Sample DataEase for Windows has been a nightmare when it comes to exporting and printing. It seems that this basic need has eluded the high and mighty...

Product: Dataease [{8}]FIVE. Written by DataEase 20/06/13 at 17:51:52

New Sample - How to manipulate records in a sub form using DatePicker()

Download SampleWe got a challenge under the AskUS "Program" so we jumped on it. It was quite nifty actually, and since it gave us an "awakening" we tho...

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

The livetext format of the new runtask (chain menu) addition to DG3

In DG3 version 0.15 we got a new addition to code that can be run on open page, the task. A task is simply a collection of code that can be run in sequence like the old DE-DOS chain menus. The difference is that in DG3 each of the ro...

Product: DataEase Generation 3. Written by DG3 Development 17/08/13 at 10:19:02

Important Fix in 8 - Table Already exist and mismatch between form and table (Ver. 8.0.0.1364)

DataEase 8 development has branched out. Up till now we have solely focused on adding new functionality to 8 and bug fixing has only been done when related to new functionality or old functionality impacted/used/involved in new functiona...

Product: Dataease [{8}]FIVE. Written by DataEase 20/08/13 at 16:33:08

Fix in 8 - Delete Table/Form directly in Catalogue (Ver. 8.0.0.1369)

A lot of "stubborn" problems have persisted in DFW for ages, some all the way back to Express. One can ask if it is the bug that has been "stubborn", the developers that has been ignorant, or the management that has been bad... ...

Product: Dataease [{8}]FIVE. Written by DataEase 30/08/13 at 11:57:03

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

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

DataEase 8.2 - Editable Form Virtual Fields (Ver. 8.2.0.1586)

Download Sample Earlier in the DE8 development we enabled Virtual Columns to be editable. You can question why this is a good idea, but the answer is that it is a VERY good...

Product: Dataease [{8}]FIVE. Written by DataEase 18/08/14 at 17:36:22

DataEase 8.2 - Encoding for prohibited characters implemented in all String Functions (Ver. 8.2.0.1600)

It has always been "Impossible" to include prohibited characters in DE derivation/scripts. Characters like New Line (CR), Tab and " (Quote) which are very useful to get in there, has been very difficult to shoehorn in.When I first started on D...

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

DataEase 8.2 - Forgotten Treasure: SetStyle()

Download SetStyle() Sample It would be a lie if we said that developing a product like DataEase 8 or even DataEase in general was done by designing the product and then implem...

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

How to: Create your own SpeelWeekday() and yes/no for language support

Download Sample The main problem with using an English version of DataEase is things like Spell functions and yes/no. These are functions that a lot of users have grown fo...

Product: Dataease [{8}]FIVE. Written by DataEase 30/09/14 at 22:25:27

DataEase 7.x and 8.x - Problems and Workaround for Installing Form with Table and Data.

We have just tested this and it works "fine".We suspect that the problem is not really related to DE 8.2.0.1679 but a general problem with Installing Forms with Tables (TDF) and Data (DBM).When you select a Document during install it w...

Product: Dataease [{8}]FIVE. Written by DataEase 14/11/14 at 12:40:33

New Sample - How to use a subform as a Dynamic Pick list for all your fields (Ver. 8.2.0.1686)

Download Dynamic Picklists SampleCTRL-F10,&nbsp;Dynamic Lookup, Open related, Lookup Fields, Multibox... So...

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

New Sample - Using Subform as Open Related Dialogue with multiple returns (Ver. 8.2.0.1686)

Download "Open Related"&nbsp;Sample Open Related is a "awkward" and outdated way of doing "picklists". As you have pointed out it is slow and you can only really r...

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

DataEase 8.2 - GetCurrent("Xpos" and "Ypos") for objects added (Ver. 8.2.1.1691)

Downlaod Updated PickLists App AIf you are familiar with our latest "play thing" MoveObject() you would also be aware that there has been some shortcomings. As...

Product: Dataease [{8}]FIVE. Written by DataEase 19/11/14 at 16:15:24

New Sample - How to use a Subform as a Modal Dialogue (Ver. 8.2.0.1695)

Download Modal Dialogue Sample As you might have discovered by now, one of the main goals of DE 8 is to allow the developer to develop contemporary and advanced...

Product: Dataease [{8}]FIVE. Written by DataEase 22/11/14 at 13:33:49

New Sample! Emulate OpenRelated (F10) to allow search in "related" form. (Many COOL functions)

Download Sample! WE have a lot of question about OpenRelated(F10) and why you can't break the filter and search freely in the related form. OpenRelated() is d...

Product: Dataease [{8}]FIVE. Written by DataEase 24/02/15 at 18:13:12

Application that Showcase how you can write-protect and search with paste in a Form.

Download Sample! In the attached sample we use SetState(), Custom Menu and Custom Toolbar to "force" the user to use our functionality correctly. Se...

Product: Dataease [{8}]FIVE. Written by DataEase 20/03/15 at 10:47:38

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

For our new users: How to calculate time and some other stuff...

Download Sample! Time computation in DataEase is very straightforward as you have a tim...

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

How to limit the input in a subform to an exact number of records.

Download Sample! We solve this with new DE8 features. A subform works as follows. If you fill all the visi...

Product: Dataease [{8}]FIVE. Written by DataEase 03/11/15 at 11:41:36

Re:How to limit the input in a subform to an exact number of records.

This is perfect!But, how do we handle if we have two sub-forms?...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 04/11/15 at 00:51:48

Re:Re:How to limit the input in a subform to an exact number of records.

Hi Arul.&nbsp; It is all there in the first reply.... I guess you read to fast ;-) 1. Record object is always called Record1, and they cannot be renamed. The slight confusion is that when you create a form or a subsequent subform, th...

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

DataEase 8.5 - AutoRefresh Form and other nifty tricks (8.5.0.1918)

Download Sample! We guess this is a good opportunity to show an alternative method to OpenRelated() with better developer control, and also how to m...

Product: Dataease [{8}]FIVE. Written by DataEase 26/11/15 at 11:15:46

ScrollTo added to SetCurrent() - Force your document to scroll with programming (Ver. 8.5.0.2096)

Download Sample! Even though we are getting close to DataEase 8.5 Production release, the deve...

Product: Dataease [{8}]FIVE. Written by DataEase 08/01/16 at 14:24:52

New Sample: How to manipulate an image in a form

Download Sample There is two ways to display and image based on field in DataEase 8.5 ...

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

Re:Pre-Release of DataEase 8.5 Developer and DataEase 8.5 Player. Thank You! What about trial licenses for both ?

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Ihor Zakharchenko 18/01/16 at 09:32:11

Re:Re:Pre-Release of DataEase 8.5 Developer and DataEase 8.5 Player. Thank You! What about trial licenses for both ?

You can use any valid DE8 license both Trial and Full.We don't issue trial licenses at the moment....

Product: Dataease [{8}]FIVE. Written by DataEase 18/01/16 at 13:59:56

Re:Re:Re:Pre-Release of DataEase 8.5 Developer and DataEase 8.5 Player. Thank You! What about trial licenses for both ?

Will wait for trial license then. It is normal&nbsp; for Ukraine reality now ;)...

Product: Dataease [{8}]FIVE. Written by Ihor Zakharchenko 18/01/16 at 15:56:44

How to highlight active record in a subform by using GetCurrent("RowNumber"), SetStyle(with * and #) and GotFocus/Mousdown.

Download Sample We got a very good question o...

Product: Dataease [{8}]FIVE. Written by DataEase 28/01/16 at 11:26:05

DataEase 8.5 New Features - Window Manipulation including Modal Forms. (Ver. 8.5.0.2172)

Download Sample! It is not an exaggeration that Window handling in DFW has been hopeless! ...

Product: Dataease [{8}]FIVE. Written by DataEase 12/02/16 at 14:18:58

Available Products, De-supported Products and available for licensing

We frequently get enquires about the availability of older versions of DataEase as well as the status of bug fixing/support for these products. Above you see a t...

Product: Dataease [{8}]FIVE. Written by DataEase 01/03/16 at 10:59:49

New Release of 8.5 - Toolbars etc. now properly sorted and virtual Forms (Ver. 8.5.0.2222)

If you have been using the later releases of DataEase 8.5 and experimented with switching on/off toolbars/tabbars etc you might have experiences some peculiar behaviour....</p...

Product: Dataease [{8}]FIVE. Written by DataEase 11/03/16 at 12:14:27

Getting Started with DataEase for Windows 8.5

Welcome to DataEase 8.5 community!&nbsp; Are you completely new to DataEase for Windows (DFW)?&nbsp;We'll help you learn how to get started with DataEase, explore and learn the basi...

Product: Dataease [{8}]FIVE. Written by Fatma Adel 04/04/16 at 11:21:04

Re:DataEase 8.5 - AutoRefresh Form and other nifty tricks (8.5.0.1918)

Sample updated to 8.5.1 version. Will not work in previous versions of DataEase 8.x...

Product: Dataease [{8}]FIVE. Written by DataEase 13/04/16 at 16:58:20

LegEasy4DOS: How to map drives in session for input/output and use them to take a backup.

In this video we show you how you set up a session and map the default input/output drives. LegEasy4DOS run in i...

Product: LegEasy DOS. Written by DataEase 15/06/16 at 14:34:22

DataEase 8.5.0.2275 - Big DEOS Update Added DEOS function @zip, @unzip, @CopyDirectory, @CopyFile, @CreateDirectory, @DeleteDirectory, @DeleteFile, @DirectoryEmpty, @DirectoryExists, @FileExists, @BrowseForFile and @BrowseForFolder

There has been a number of CDFs etc for dealing with finding files etc in DFW.CDF's are well and good but important functions like this should be dealt&nbsp; with by&nbsp;DataEase directly.In 2275 we have included the following DEOS fu...

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

DataEase 8.5.2364 - jsBridge between WebFields and PRISM added to enable WebForms

WebFields was one of the earliest features added to DataEase 8 and they have been a great additions.As everything else the more you integrate and use them the more yo...

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

DataEase 8.5.0.2419 - Variable Subforms added - Change the number of rows in a Subform in Realtime.

Download Sample The old and trusted subform has been unchanged for a long time and as much as it i...

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

LegEasy4DOS - format of Install files (INSTALL.DIN) in 4.x

FORM: install form FORMNAME from: FORMNAME.dba ; ex : install form CUSTOMERS from: custaaab.dba ; Now the form/table is installed so the next bit is data. New Table: <b...

Product: LegEasy DOS. Written by DataEase 10/08/16 at 13:39:14

DataEase 8.5 - RefreshScreen() fixed to refresh entire form including Subforms (8.5.0.2456)

We are not completely sure when RefreshScreen() was introduced but most likely it has been around since the Dawn of DataDase for Windows (Express 1.0) and it has never worked....

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

GetCurrent("ScientificTime") added to GetCurrent() to give better precision for timers (Ver. 8.5.0.2500)

Download Sample When DataEase was introduced back in the early 1980ies computers where so slow th...

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

DataEase for DOS Corrupt Indexes

If your DataEase for DOS files are stored on a Windows 2008, R2, or 2012 File Server, you may be running in to a known issue with SMB Protocol (Server Configuration) Version 2 and 3. According to several online sources; you must disable protoco...

Product: LegEasy DOS. Written by DataEase 09/09/16 at 08:19:25

License terms and enforcement from April 5th 2017

It is no secret that license enforcement in DataEase has been very much a gentlemen's agreement. Some time back we started sending out warnings when a license was...

Product: Dataease [{8}]FIVE. Written by DataEase 05/04/17 at 11:49:28

New Sample - How to use jsBridge in WebField to interact with form

Download Sample! We got a request today that related to interaction between WebField (Memoexecdql etc)...

Product: Dataease [{8}]FIVE. Written by DataEase 14/04/17 at 16:45:31

Command line options DataEase for Windows 8.5 and 8.6

As part of the work with 8.6 we have brushed up on the Command line options of 8.x. A lot of the changes was actually done in 8.5 and is already available so we choose to publis...

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

NB! Old DataEase for DOS files in App Catalog cause CRASH!

We have had a number of clients that has had problems getting LegEasy4DOS to work. The problem has turn...

Product: LegEasy DOS. Written by DataEase 06/11/17 at 13:05:19

New Sample 8.5 - How to make your own Tabbed Subforms that work...

Sample Hi. Tabs was one of the big news in DataEase 7.x but as...

Product: Dataease [{8}]FIVE. Written by DataEase 08/01/18 at 15:44:58

DataEase 8.5 - How to create a subform that change style on scroll/value in row.

Download Sample The solution is to manipulate the entire Subform when there is a scroll.&nbs...

Product: Dataease [{8}]FIVE. Written by DataEase 29/05/18 at 12:43:25

New Sample - How to go to last (new) record in Subform

Download Sample We got a request on the forum on how to go to the last (new) record in a subform from...

Product: . Written by DataEase 03/12/18 at 12:52:06

DE9 - Preview of the new Zebra style for subforms and the new subform definition process.

DataEase Subform has been untouched since the dawn of time and it was high time to...

Product: DataEase 9 Developer. Written by DataEase 04/10/19 at 13:56:04

L4D - Option for Automated Server Deployment added 1.4.0.4369 (18)

A lot of our L4D usrers have 50, 100 or more users that use a single application.&nbsp; To install L4D on each machine and then configure shortcuts etc can be a big chore. An automated...

Product: LegEasy DOS. Written by DataEase 20/11/19 at 17:13:38