Simplicty and flexibility!


Visitors: 14,039,164

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

Download Sample

How to create language versions of documents has been discussed before.

How to acheive t...

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

How to print a barcode via HTML


In Principle you can use the same font in HTML.

Just need to set it on the tag.


Written by DataEase 06/04/20 at 15:17:00 Dataease [{8}]FIVE

L4D - Creating New Application in L4D and why all apps are located in B:\

You can create a new application in any location on your computer.

SImply add a name for your new application, browse to the location you want to use, and hit SAVE and the Session will be...

Written by DataEase 02/04/20 at 15:20:10 LegEasy DOS

L4D - How to print with color in LegEasy4DOS

We got a request today from a customer that was testing LegEasy4DOS. 

As he was very enthusiastic about what he could accomplish we decided to set aside some to help him...

Written by DataEase 25/01/20 at 18:21:12 LegEasy DOS

DE9 - How to use DE8 Custom Menus etc.

First thing first, you can keep your DE8 filemenus, toolbar and tab bar in DE9 (even catalog) if you want to.

You can do this either programatically via SetCurrent() ex. SetCurrent("File...

Written by DataEase 18/01/20 at 12:42:51 DataEase 9 Developer

Beta 33% 09.11.19 - A Dataease version fully built in - Dataease

The time has come and today we let the cat out of the bag - for the first time we let anyone outside our closet partner network see and play with DE9.

We call it Beta 33% but don't make that put you off. It is a fully working replacement for DE8.5 which was the first milestone we wanted to reach before we let it out.

However it is much more than that which you will quickly find out. The reason we call in 33% is because it is at this stage only 33% of our ambition for DE9.

So within these 33% you find all the functionality from DE up to and including 8.5 final with over a 100% new functionality partly revealed today and to be revealed and evenly spaced out increments over the next 3 months.

100% DataEase

LegEasy4DOS Professional is a "pioneer" that showcase the future of DataEase.

No! The future is not retro, and the bit about it that is pioneering is not the fact that you can fun DataEase for DOS applications.

That feature is basically just how it should always have been and a catch-up with our history.

Take a closer look - The entire product is made IN DataEase following up on a "slogan" we had when we sat out to refurbish DataEase.

DataEase need to be made in DataEase!

LegEasy4DOS - How it works?

The interest in LegEasy4DOS has been "overwhelming" since we released it at the end of last week.

A lot of eagerly awaiting Professional clients jumped at it and the feedback was not late to come.

Most of you are overjoyed and excited by this opportunity to run DataEase for DOS in a modern environment, and more than happy to scrap your old XP computers and Novell servers that has kept you up at night with worry - when will it draw its last breath and what will I do then?

However not all feedback is good and some of you have been "disappointed" too.

Some of this disappointment is down to us having problem with our server park after the release due to an unexpected heavy load - don't they always say that - but some of you have been running bench mark tests and compared it to "Native" DfD on Native XP, WIndows 7 x32 etc. and the results has baffled you.

Why is it sometimes much slower and then sometimes much faster than the comparison?

In the article below we will try to explain this and how LegEasy4DOS is designed and how it works.

LegEasy4DOS Professional Release 05.08.16

The response to our Personal version of L4D has been fantastic and it has given us great motivation in the work leading up to the release of our long awaited Professional version of L4D.

We won't spend too much time extrapolating its virtues here but limit ourselves to announcing it's release and showcase its beauty ;-)

Further down the article you will find the FREE FOR ALL Trial Key you can use to get the first "spin" in this brand new interpretation of DataEase (for DOS).

New Support Manager and new Support Products introduced

For a long time we have been focusing on improving our software products, but we have now entered a new phase where we will focus more and more on the entire customer experience.

One issue that has been raised more often than others is the lack of a dedicated support service so this is one of the areas were we will now focus.

Last month we hired Fatma Adel as our new Support Manager. She has now had some time to settle in and are more than eager to start helping you resolve your issues.

LegEasy 4DOS - Update!

We are and should be very happy when an upcoming release of a DataEase product cause this much of a stir, but it is also a sobering moment.

We obviously still have some catching up to do with our new products before they reach the same popularity as the early versions of DataEase.

Luckily the "re-launch" of DataEase for DOS is part of our DataEase infrastructure strategy so you will now be able to run your legacy apps well into this century when at the same time integrate them with the latest DataEase technology.

Locking Strategies for dummies!

Ever wondered why you have so much trouble with inconsistency and being locked out of your DataEase database? If the answer is YES, read one and discover how you can easily remedy it.

Full, Basic, Opportunistic - What does this really mean? We get a lot of questions about which locking to choose in DataEase, and the answers we have give - are giving, have changed over the years. I guess that if this was a simple as it "should be", there wouldn't even be three options in DataEase, and we wouldn't leave this is in your hands.

I have spent quite a lot of times over the years debating and exploring this myself, and the problem is that it is more of a philosophical problem, than a technical one. Pictures this as going into a Chinese restaurant and ordering. You get a many with 500 items, and you are vaguely familiar with 3 of them, so what do you do. Choose what you know, or go for the set menu...

[{8}]five Release and Release program.


DataEase {[8}]five went into production today and from now on it will be all about 8.5 and beyond.

We have now concluded the longest Beta program in DataEase history - 427 days or over 1 year and 2 months.

So why so little fanfare on this watershed day?

Warning! Price increase on DataEase 8 from January 1st

We are changing how we license DataEase from Januar 1st 2016.

In short we will stop dividing licenses (and executables) in Developer (Full) and GROUP (Runtime) and introduce a simple User License and one executable that will be either a development environment or a Application Launcher based on the users privileges.

The change might seem dramatic at first, but you will get much more functionality and flexibility.

This is just an early warning to those of you that plan to buy DataEase 8 in the near future, more information on the change in product and licensing strategy will follow.

Dynamic Design - A New paradigm in DataEase development

ExecDQLClass(), CreateTable(), AddColumn()* signify a complete breach with previous DataEase thinking.

From its infancy in the early 80ies and throughout its life until DE8 there was a clear divide in DataEase between Design and Runtime. (At least in the head of the designers, but the fact that most people used it interactively and added and changed to it in real time was not taken into account)

Tables, Scripts, Forms, Reports was froozen in runtime and there was few if any way you could make your application dynamic.

How this has changed in 8....

How to create CDFs for use in DE8/DG3

This is how you create your own CDFs using Visual Studio 2013. I selected to use this version because any one can get a full version for free as long as you register with MicroSoft. You should be able to recreate this in any version of Visual Studio in almost the same way as described here. Not much has changed in creating Windows DLLs in the last 20 years. You probably can do the same using other compilers as MinWin GCC and Embarcadero, but that is outside the scope of this document.

Migrating from DFW 5.x and 6.x to DE8.5 including National Versions

If you want to encompass DataEase problems in one word it must be Migration. It is fascinating that a company that has had so little success with this concept, has sworn to it for such a long time.

It is a badly hidden secret that DataEase lost most of it users in the flawed and bodged migration of DFD application to early DFW, what is maybe not so well know is all the other "unsuccessful" migration events.

In this article we will explain what/why and how it went wrong and what you can do to work around it.

We reached our 1.000.000 visitor today 23rd of February 2015

At the beginning of the year we had estimated that we would get our 1.000.000 visitor at the 6th June this year, but with the Beta of 8.5 and the great feedback we have seen both visits on our website and sales sky-rocket and we reached the 1.000.000 threshold more than a Quarter ahead of schedule!

We just have to thank you all for your patience with us, and for your contributions and support throughout the last couple of years since we took charge.

We both hope and feel that our efforts and enthusiasm for DataEase has been well received and are reciprocated by you all!

A wholehearted thank you to your all from "The DataEase Team".

NEW! Functions in DataEase 8.0 to 8.5 (Page 1)

Some of you might be aware of it but it seems a lot isn't so it might be time to advertise a little the vast number of new functions and functionalities that has been added to DataEase 8.0 through 8.5.

For a long time the only way new functions found their way to DataEase was through active and ingenious users which developed CDF's. As much as the CDF's alleviated the obvious short-comings in DataEase 5.x to 7.2 it was cumbersome, undocumented and "secretive" i.e. not everyone was in the know.

With 8.x we decided that the focus needed to be on moving DataEase forward, rather than the constant dance around the "bug fixing" fire.

Have a look and a try for yourself.

Due to the number of new functions we had to publish the short description in two articles, of which this is the last.

Also have a look on the blog synopsis found in the list to the right.

Start your own thread!

07/08/20 13:35:47


There is a lot of hoops you have to jump through to get this working now.

if it is in 32 bit windows it is more straight forward but as 7.2 is a 32 bit software it will only work with 32 bit ODBC.

If you are running 64 bit windows you need to start the 32 bit ODBCadmin as the link need to be 32 bit!

When you have set up the link in ODBCAdmin

You simply add it in the database links in DE.

The Link name is not important, that is just the name it will be stored under in the Catalog and can be anything.

You then choose Engine type (Other Engines via ODBC)

Then you add the Server Name which is the name it has in ODBC Admin in this case AgeEange and simply hit Add.

YOu will then see the available Tables List.


As this interface has not been updated for a long time the match between ODBC and DataEase is poor and as the statements from DataEase is converted to SQL and back more often than not you will get problems with updates and reading as there is a mismatch.

So if you are to use this you should build views etc. in the donor database that match with DataEase or you will not get it working.

We did quite a bit of work on the ODBC/OLEDB stuff in 8.x but in the end we had to chuck it in as the model is outdated and slow.

in DE9 onwards we use HTTP based REST API model for exchange of data.


Product: DataEase for Windows 7.x

Written by: DataEase

05/08/20 19:08:29


Hello good afternoon can someone help me configure ODBC to fetch acces data to DataEase 7.2.3 Thanks for the collaboration


Product: DataEase for Windows 7.x

Written by: diego fernando Ocampo

31/07/20 10:31:24

Re:LegEasy4DOS Support dataease versions and supported windows OS

LegEasy4DOS support 4.53 and 5.53 as default and will run all DFD 4.x and 5.x apps. It will run on every windows version from Windows 7 onwards for desktop and 2012R2 on Server.

We hope this helps.

You can download and test it on any device (as many as you like) for 30 days.


Product: LegEasy DOS

Written by: DataEase

30/07/20 16:58:54

LegEasy4DOS Support dataease versions and supported windows OS

Will LegEasy4DOS run on windows OS 2016 and OS 2019 ? Does it support apps written using dataease 4.53 and 5.15 ? Thanks


Product: LegEasy DOS

Written by: Guy Harwood

23/07/20 20:03:21

Dialog box to carry out the invoice collection process generated from a main sales form.

Is required:

With the "Action" button the dialog box calls an event that performs the paymentfunction, save the sale that is active in the main form and close this.

With the "exit" button the dialog box closes and calls an event that returns to the sale that is active in the main form and allows you to continue with its functions.


Product: DataEase for Windows 7.x

Written by: EaseSoft Ltda

19/07/20 10:02:10

Re:Re:Re:Re:Re:Re:Home vs Forum after redesign


Product: Services

Written by: Ihor Zakharchenko

17/07/20 13:41:08

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 other relationships when you change the query.

A new query in DataEase result in a completely new multiview and for some reason the OML stuff is not part of the new multiview and hence the any will hit the unfiltered "virtual" relationship and return the first row in the table.

We have fixed this in DE9 but obviously this bug is still there in 8.5.

The best way to get around this is to use the standard memoexecdql() "Hack" of adding a virtual ExecDQL and Relationship key in the form. 

You can also use LabelExecDQL() and hide the code with SetState().

In DE9 you will be able to run DQLs stored in the system execdqlstore table directly with ExecDQL("#0005" etc. or ExecDQL("@Dqlname here" etc or use AnyLookup() to look up data without a pre-existing relationship.


Product: Dataease [{8}]FIVE

Written by: DataEase

15/07/20 08:03:31

Re:Re:Re:Re:Re:Re:Re:MemoExecDql running on filtered records

So, due to the DataEase team replies we will interact with Apple company to make new macOS run DE 9 ;)


Product: Dataease [{8}]FIVE

Written by: Ihor Zakharchenko

15/07/20 08:03:31

Re:Re:Re:Re:Re:Re:Re:MemoExecDql running on filtered records

So, due to the DataEase team replies we will interact with Apple company to make new macOS run DE 9 ;)


Product: Dataease [{8}]FIVE

Written by: Ihor Zakharchenko

07/07/20 16:41:18

Re:Re:Re:Re:Re:Re:MemoExecDql running on filtered records


Product: Dataease [{8}]FIVE

Written by: Ihor Zakharchenko

07/07/20 16:37:09

Re:Re:Re:Re:Re:MemoExecDql running on filtered records

...only migration tool can work ... but 9 beta is better for it can start ..8.5 can not ...


Product: Dataease [{8}]FIVE

Written by: Ihor Zakharchenko

07/07/20 16:36:12

Re:Re:Re:Re:MemoExecDql running on filtered records


Product: Dataease [{8}]FIVE

Written by: Ihor Zakharchenko

07/07/20 16:04:06

Re:Re:Re:MemoExecDql running on filtered records

will try it on macOS Big Sur 11.0


Product: Dataease [{8}]FIVE

Written by: Ihor Zakharchenko

07/07/20 14:50:46

Re:Re:Idea: Chance to try DE9 on macOS Big Sur presented on WWDC 2020 by Apple

got it on macOS X 10.16 Beta Big Sur via Crossover Sofware installer at last. But DataEase 9 Beta still showing blue screen and nothing more ...please help, dear Dataease team.


Product: DataEase 9 Developer

Written by: Ihor Zakharchenko

07/07/20 14:48:47

Re:Idea: Chance to try DE9 on macOS Big Sur presented on WWDC 2020 by Apple


Product: DataEase 9 Developer

Written by: Ihor Zakharchenko

07/07/20 11:30:35

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

06/07/20 23:21:27

Re:MemoExecDql running on filtered records

Hi Marco.

Sounds strange. We know that some strange things can happen when you combine OML and ExecDQL. 

We will try to see if we can replicate the problem and get back to you.


Product: Dataease [{8}]FIVE

Written by: DataEase

04/07/20 09:16:32

MemoExecDql running on filtered records

Hi DataEase

I 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


define "a" numeric string 1 .

assign a:= setvar("TImportoFidoRichiesto",ImportoFidoRichiesto.value) .

assign a:= setvar("TImportoFidoRichiesto_DiCui_Bondanet",ImportoFidoRichiesto_DiCui_Bondanet.value) .

assign a:= setvar("TContraente", Nome_Contraente.value) .

assign a:= setvar("TNote",Note.value) .

a := MemoexecDQL(any DQLStore with (DQLNumber = 0005) DQLScript , N_Protocollo.value , "" , "" , "" , "" ) .

a := keystrokes ("_ctrl(r)") .

if getvar("CheckEvasione") = "OK" then

message concat("Richiesta Analisi finanziaria eseguita. Protocollo N. " , N_Protocollo.value) window .

a := FormClear() .

end .


The procedure works well but if a filter is made by the user on this form the DQL launched does not correspond to the number indicated on the expression with, i.e. the DQL 0001 is launched instead of the DQL 0005

I tried to :

1) reorganize the DQLStore table (no results)

2) change the format of the DQLNumber field from numeric string to number (no results)

3) I entered named "xxxxxxxxxxx" in the MemoExecDQL command (no results) I tried also combination of point 2 and 3

4) I try to run memoexecdql via execute function derivation without using OML (no results)


there is no relationship on DQLStore (I think it is right so )

Any suggestions?


Product: Dataease [{8}]FIVE

Written by: Marco Marchesi

04/07/20 08:13:30

Re:Re:Compatibility DataEase 8.5 with multi-user Citrix Environment

an example please then. thx


Product: Dataease [{8}]FIVE

Written by: Ihor Zakharchenko

03/07/20 18:15:02

Re:Compatibility DataEase 8.5 with multi-user Citrix Environment

DataEase 8.5 was not designed to be compatible with a Citrix environment. To be honest I don't think any software really is as Citrix basically is a band-aid for applications that can't be hosted directly as cloud based software.

However it works well running with multiple sessions on a server (we have run as many as 150 simultaneous sessions on one server in production).

We have a number of customers that run DE8.5 on many different platforms like this and they are all very happy.

We hope this helps.


Product: Dataease [{8}]FIVE

Written by: DataEase

DataEase Mainpage