Simplicty and flexibility!


Visitors: 14,345,427

Radioboxes - how to filter on them and clear them

Download Sample

You can of course add a choice (default maybe) that is None or something like...

Written by DataEase 01/02/21 at 11:08:34 Dataease [{8}]FIVE

DE9 - A quick preview of the NEW interactive DQL editor.

Just a quick preview to show you all that we are not just relaxing here at DataEase

As you can see it is just a simple test done in the "horrible" Club ParaDEASE. Enjoy

Written by DataEase 18/11/20 at 21:06:06 - 4 people have commented. The newsest comment is 110 days old. DataEase 9 Developer

How to edit RDRR file to connect lost files.

All of you will at some stage get the problem when you change a form/table that it crash and the file is "lost". 

it is never lost.

The data is still there in a Temp Form XXX table. The problem is that the change crashed in the mi...

Written by DataEase 10/09/20 at 13:33:54 Dataease [{8}]FIVE

"System error: Relationship limit 255 exceeded. " - Understanding Relationships in DataEase

In regular intervals we get support request in regards to this message and what you can do to increase the limit to OPEN relationships in DataEase.

If you are "lucky" you get this problem wi...

Written by DataEase 03/09/20 at 10:53:34 Dataease [{8}]FIVE

DE85- 100% control of the USER!

Download Sample

We got a request on the form about how to use Modal and switch between f...

Written by DataEase 19/08/20 at 14:32:40 Dataease [{8}]FIVE

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!

27/07/21 12:12:03

Re:Modify operation stops after doing 48 records.

There is no limits in DataEase but you might have inadvertently bit your own tail.

Firstly don't mix delete and update in the same DQL. I can't see you have done this but it can catch itself out.
When deleting records in a DQL on a multiuser platform use
For etc..
Delete records.

And not:
delete records in etc..

The last one will only work if all records you try to delete is not used by another user/process.

For Agree2 with CliNum = any AgreeDeleteStart CliNum ;

list records

IDCode .

for AgreeParties2 named "SomethingUnique" with field1=field2 etc. -- this will override any other relationship that might exist

modify records

NameLast := "zzz".


I suspect that the problem is that the relationship is more restrictive than you want so by overriding it you will know what relationship you are using by using an adhoc one.*Named*


Product: Dataease [{8}]FIVE

Written by: DataEase

26/07/21 16:41:25

Modify operation stops after doing 48 records.

Is there some setting I need to change?

We have written procedures to first modify records in a table, and then subsequently delete the modified entries. We decided to do it in two steps out of an abundance of caution, so that the correct entries and only those are removed. This seemed to work smoothly, until we got to a bigger collection of entries. For the particular CliNum there were 165 entries in Agree2. The procedure changed 48 of them and stopped.

Here is the script:

For Agree2 with CliNum = any AgreeDeleteStart CliNum ;

list records

IDCode .

for AgreeParties2

modify records

NameLast := "zzz".


Agree2 is the main table, AgreeParties2 is related via CliNum.AgreeDeleteStart is another table related through CliNum, where make just one entry.We run this procedure, another one to delete the changed entries with “zzz”, and four others on related subforms of Agree2.

I don’t understand why this changes 48 entries, then stops.

Is there some global setting that controls this?  am unaware of ever making such a setting.I hope someone might have a clue.

Running the procedure again gets the same result. Only after manually deleting the first 48 entries in Agree2 does this procedure go further – and then just 48 records, again.


Product: Dataease [{8}]FIVE

Written by: Bonnie Clarke

16/07/21 15:20:54

Re:Re:Lookup Table List A to Z Order

In DE9 this will be a breeze. One of the many new features will be the updated Multibox which now features both Unique values (no doubles in list) Sorting and caching. You can also limit the number of returns you get in any list.

hen you use the Multibox we have also added searching in the following way.
1 and 2 character it will search from the beginning of the word.

3 and more characters typeahead it will search in the entire text and return all the choices that match.


Product: Dataease [{8}]FIVE

Written by: DataEase

16/07/21 13:51:58

Re:Lookup Table List A to Z Order

Download Sample

Hi Steve.
The good news is that you can do this if you look up with a filter but the bad news is that it won't work if the filter is just  * (someone obviously thought it a good idea to just load all the data when you do this without thinking of the feature you are looking for.

I've attached a simple application for you to look at so you see the necessary steps to achieve this.

There is also something called Performance or clustered index. This means that the table is sorted according to the index when reorganized. This is a good way of making alphabetised lists if the data is not to dynamic (so maybe not too good when its customers etc.)

I have included how to do this in the sample too. Just remember to choose cancel when you close SomeLookup as it will otherwise close the app ;-)


Product: Dataease [{8}]FIVE

Written by: DataEase

15/07/21 10:04:03

Re:Can i buy and develop applications now?

Hi DataEase 9 will be released for sale this autumn.

All the best.


Product: DataEase 9 Developer

Written by: DataEase

13/07/21 20:28:22

Can i buy and develop applications now?

Can i buy dataease 9 and develop applications now.  Does dataease host the applications? 


Product: DataEase 9 Developer


03/07/21 21:24:08

Lookup Table List A to Z Order

I have created a form which looks up clients in a related table, this works fine except it would be nice if the table list was in A to Z order, this would enable the data entry user to easily pick off the correct option.  Is this possible?


Product: Dataease [{8}]FIVE

Written by: Steve_C

30/06/21 11:41:11

Re:Re:Re:EDATE Excel function equivalent in DataEase

Hi again Robert.
In a way I think that the way DataEase should work - had to test if it actually worked like this but it didn't.

12/01/32 + 00/03/00 should be 12/04/32
12/01/32 - 00/03/00 should be 12/10/31 


I will check with the boys/girls and we discussed it and decided to include a function in DEOS() that can add months, years etc.

DEOS is the big exciting functional news in DE9.

It is like our own operating system inside DataEase and will be worth a study on its own.

The format will be.

DEOS("@DateCalc",31/12/20,"Month",-3) will be 30/09/20 etc.


Product: Not product specific.

Written by: DataEase

27/06/21 10:05:55

DataEase. A collection of original manuals and utilities from 1980/90s

I have had permission to advertise that I am offering all my old DataEase manuals for sale. I have listed all the items on Ebay as a simple way to list and post photographs, however, Im not expecting a rush of interest from the general public. They could be useful to developers who need to know what we were using back in the last century!!. If anyone is remotely interested in taking the lot, then Im happy to negotiate a price. 

 eBay item number:   144090934447

Ebay allows the listing in quite detail, and there is quite a lot of stuff I collected, some my be useful to someone.


Product: DataEase for Windows 5.x and before...

Written by: Alan Hayward

26/06/21 01:23:57

Re:Re:EDATE Excel function equivalent in DataEase

Thanks Very Much!  I appreciate you taking the time to reply and advise.

Your suggestion is what I thought would be the way to achieve the same result.  I'll try to understand the algorithm MS uses in their EDATE function to get the very accurate result it does and then apply it using the Date functions you mentioned.

The great thing is that if DataEase doesn't have the identical function, we can most always build a solution that gets the same result.

We operate a business where expiration dates are very important so we'll get it to work.

If your team is considering new functions for a future release, this may be a good one (slight Hint ??).

When I build a work around, I'll come back to the thread and post it.



Product: Not product specific.

Written by: Robert Smith

25/06/21 16:09:24

Re:EDATE Excel function equivalent in DataEase

There is no function to do that but there is several ways to achieve the same.

In DataEase you can add and subtract days from any date and it will return the correct date.

Obviously with months being so "stupidly" configured i.e. 28, 29, 30 or 31 days that is not always a good way.

Then you can deconstruct and re-construct a date.

Month() and Year() and Day() will give you the individual numbers.
YOu can then do your maths on months but have to take care of the carry overs like 6-11= -5 then subtract one from year and -5 from month etc.

When you have the correct year,month,day simply rebuild the date with 


Product: Not product specific.

Written by: DataEase

24/06/21 17:07:40


Hi. NO that is just temporary memory files.


Product: Dataease [{8}]FIVE

Written by: DataEase

24/06/21 17:05:25

Re:sspq virus

You can easily enough rename them in dos.

Rename *.frm.sspq to *.frm but I'm afraid it will do little good.

The files are encrypted so they would still not work.

THis is a find a backup situation.,SSPQ%E2%80%9D%20extension.&text=This%20key%20is%20the%20same,encrypted%20during%20a%20ransomware%20attack.


Product: Not product specific.

Written by: DataEase

24/06/21 16:13:30


YOu mean to copy into fields?

Yes. You should be able to use the shortcuts.CTRL-C/CTRL-V


Product: LegEasy 4DOS

Written by: DataEase

24/06/21 07:56:53


can you find anything that helps in my *.tmp 

thank you


Product: Dataease [{8}]FIVE

Written by: Rainer

24/06/21 06:38:08

Re:Re:Re:Re:Dataease Excel Version

Do you mean viewing your form data in a table?  I've never seen a DataEase application function like MS Excel


Product: Not product specific.

Written by: Robert Smith

24/06/21 05:54:04

EDATE Excel function equivalent in DataEase

Hi All,
Does anyone know of a function in DataEase that is functionally equivalent to the =EDATE function in MS Excel ?
This is an extremely useful function used to calculate a date when you add or subtract any number of months to any date.

I've uploaded a sample spreadsheet demonstrating how the EDATE function works

I'm not a DataEase expert so if anyone out there can help, I would be grateful and I know others would appreciate it

Thanks All !


Product: Not product specific.

Written by: Robert Smith

23/06/21 14:35:15

sspq virus

Hie dataEase

Files of one of my databases have been affect by sspq virus. it gives all files .sspq eg

RECSTAAF.FRM.sspq. Which software can actually remove these extentions


Product: Not product specific.

Written by: Godfrey

22/06/21 14:47:37

Copy & Paste in LegEasy 4DOS

Hey guys,

is it possible in Legeasy 4DOS to directly use copy and paste e.g. from a browser tab?

Thank you very much.


Product: LegEasy 4DOS

Written by: test test

15/06/21 15:19:34

Re:Copy Button

Download Sample

Hi Troy.

What you try to do here is not straight forward but quite easy from DE8 onwards.

It is possible in DE7 to but then you have to do it OML.

Look at the sample.

You can downlod a 30 day trial of DE85 from our download page.

30 Day Trial Key: D85-TRIAL30DE85-38347


Product: DataEase for Windows 7.x

Written by: DataEase

DataEase Mainpage