Simplicty and flexibility!

-

Visitors: 16,394,084

LE9-How to call ExecDQL directly from code

ExecDQL started small and is now all-encompassing. What started as a way to execute a DQL for processing with no output now powers websites and has taken on a life on its own w...

Written by DataEase 08/11/24 at 15:16:23 - 1 people have commented. The newsest comment is 175 days old. LegEasy 9 Developer

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 1,484 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

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.

Finally...

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.

NEW! ?Functions in DataEase 8.0 to 8.5 (Page 2)

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

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

Start your own thread!

29/04/25 09:50:12

Re:Re:Re:Re:Change Text Colour

I will look at DE9 again - looking at it last time I could see the potential for moving forward with it, but must say it’s scary with so many hidden “If’s and oml’s" hidden all over the place inour program , plus I’m not sure if I will be able to down load another demo version of DE9 as I tested it a year or so ago.   

...

Product: DataEase 6.x

Written by: Handles

29/04/25 09:31:08

Re:Re:Re:Change Text Colour

There is a lot of customers that has stayed in DE6 due to problems moving forward due to exstensive use of CDF's and hacks to get things to work "exactly" as they want to.

But we see an increase in people that has stayed in DE6 that now simply have to move forward and obviously the leap to DE9/DE10 will not get any smaller with time passing.

The focus on migration to DE6 was in DE8.2 really where we re-introduced what has been left out in DE7 but due to compatibility with DE7 taking priority there is certain things that one simply had to re-design moving from DE6 and before. 

In LE9/DE9 you have opportunities that one can just dream of in DE8.5 and obviously even more so if one is in DE6. However one will have to put some effort into moving the application forwards but it would be well worth it.

Most of the things that one did a lot of programming to get in DE6 comes for free in LE9/DE9 but one need to look a things with fresh eyes.

One will also be able to "spread ones wings" with options of sharing the Application with our Web Suite that will allow you to build a modern web interface on top of your DE9 application without it affecting the running of that app at all.

...

Product: DataEase 6.x

Written by: DataEase

28/04/25 17:04:45

Re:Re:Change Text Colour

Thanks for the reply, I will give this a try - hopefully all goes well, I have tried the Version VE9 but some of the thing I have program in DE6.53 just will not work in DE9 - and its a very large database too large to start changing thing unfortunatley.   

...

Product: DataEase 6.x

Written by: Handles

28/04/25 11:53:24

Re:Change Text Colour

Download Sample
Hi.

This is quite straight forward in DE6 but evern more so in LE9/DE9.

The attached example is in LE9 as we don't do work in DE6 anymore but the first examples should work the same in DE6. 

As you do the action directly on the object you can leave out the object name and use a general reference.

Fully written out it would be:

if DataEase6Compatible.Value="0" then

DataEase6Compatible.fill.color.red :=255 .

DataEase6Compatible.fill.color.green := 0 .

DataEase6Compatible.fill.color.blue := 0 .

else

DataEase6Compatible.fill.color.red :=255 .

DataEase6Compatible.fill.color.green := 255 .

DataEase6Compatible.fill.color.blue := 255 .

end

The benefit of using the general reference is obviously that the code can be copied onto other objects without having to be modified. 

Same goes for the DE9 sample.

Here we use Style rather than RGB. This way you can change the look of the field via changing the style rather than having to change the code on each field. Hard coding is never a good idea as its a big job to "change your mind".

define "retval" text .

if value = "0" then

retval := SetStyle(Name,"Red") .

else

retval := SetStyle(Name,"Normal") .

end

So basically what we do here is to check the value of the current object, if its "0" (value is always text) so if you want to change it to number you can simply do value+0 which will automatically change it to a number. 

we use a dummy variable to call the funciton SetStyle and then we use the property Name which will be the name of the current object and then set the style "Red". or "Normal". You can then change the style Red as much as you please and everywhere its used it will change.

...

Product: DataEase 6.x

Written by: DataEase

27/04/25 09:35:31

Change Text Colour

6.53..

I want to change the text colour in a filed from black to red if the filled = 0, so something like , 

(if field2 = 0 tex.colour RED else text.colour Black)

any help please  in correct format 

...

Product: DataEase 6.x

Written by: Handles

17/04/25 22:34:35

Re:Re:Re:Re:Re:Re:Re:Re:Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!

Thank You, Dear Suzanne! 

...

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

Written by: Ihor Zakharchenko

07/04/25 18:30:32

Re:Two reports to one pdf file

Hi Blessed!

There is many tools online where you can do this for free.

There are ways already you can achieve this with ExecDQL by calling DQL's as part of other DQL's. We will get back into this later on but for now you can only generate one continues PDF from a DQL/Report. 

When they are generated you can combine the with third party tools.

We might look into adding a DEOS functions to "concat" PDF's but at the moment we have to much other stuff to make and its not pressing as there is so many third party tools that do this.

However we have ourselves felt the "want" if not the "need" for a function like this.

...

Product: Dataease [{8}]FIVE

Written by: DataEase

06/04/25 15:58:54

Two reports to one pdf file

Is it possible to combine two different reports to print to one pdf file?

...

Product: Dataease [{8}]FIVE

Written by: BLESSED SHUMBA

21/03/25 18:56:50

Re:Re:Re:Re:Re:Re:Re:Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!

may be ..sanctions ;) U r welcome ! at Your service <3

...

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

Written by: Ihor Zakharchenko

21/03/25 16:40:12

Re:Re:Re:Re:Re:Re:Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!

It did not accept the Cyrillic ... Bol'shoye spasibo!

...

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

Written by: Suzanne Michelle

21/03/25 16:02:48

Re:Re:Re:Re:Re:Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!

Thank you, thank you, thank you!!! That's exactly what I needed!

??????? ???????!

...

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

Written by: Suzanne Michelle

21/03/25 12:24:35

Re:Re:Re:Calculating Number of Months

not bad

...

Product: DataEase 8.5 Runtime

Written by: Ihor Zakharchenko

21/03/25 12:20:34

Re:Re:Re:Re:Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!

...

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

Written by: Ihor Zakharchenko

20/03/25 18:26:30

Re:Re:Re:Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!

Publisher of DataEase ... 

...

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

Written by: Ihor Zakharchenko

20/03/25 15:38:26

Re:Re:Calculating Number of Months

... assumes stop-date >= start-date

if year(stop-date) = year(start-date)
then Months = month(stop-date) minus month(start-date) plus 1

else Months =
12 minus month (start-date) plus 1 ... beginning stub
(year(end-date) minus year(start-date)) times 12 ... great middle
month (stop-date) ... ending stub
end if

Per example ...

... 12 -5 +1 = 8
... plus (2025 - 1999) *12 = 26 * 12 = 312
... plus 8
... total is 328 months

...

Product: DataEase 8.5 Runtime

Written by: Suzanne Michelle

20/03/25 15:22:53

Re:Re:Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!

Who is "Ulrik and his great DataEase" ... what does it do?

...

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

Written by: Suzanne Michelle

20/03/25 14:39:01

Re:Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!

THANK YOU, DE Customer Care Team!! The first menu is what I am looking for ... any more samples like that?

I cannot easily download the software and use it here at work, very complicated environ.
First off, would it run on (a) Win 7 PC? (b) Win 10 laptop, (c) Win 2019 or 2022 server (in a session, not shared)? ... I do have control of my servers, and maybe could try that.

Kind regards,
Suzanne

PS - where -is- "The Old Chapel"?

...

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

Written by: Suzanne Michelle

20/03/25 13:47:31

Re:Re:Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!

Dear Suzanne! Thi is the screenshot from Microsoft Lumia 950. The software is DE 4.53 EN

...

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

Written by: Ihor Zakharchenko

20/03/25 06:56:21

Re:Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!

Hi, dear Suzanne! Everything You need :) i.e. working DE 4.53 SQL is here on this IBM monster. Also it is on Microsoft Lumia 950 .. see my cover photo on Linkedin and ..on Samsung Gear 1 watch ..the pic is on Facebook ;) You've real experience with Dataease Intl and PLM Consulting so we may have meeting in NY ... I propose coffee or something alike  You love for You. For all of you including Ulrik and His Great DataEase are supporting us in Ukraine during the war now. Thx a lot heartly <3

...

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

Written by: Ihor Zakharchenko

19/03/25 23:43:27

Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!


Hi Suzanne.

Thank you for the nice story but I think we can do you one better.

Just download the LegEasy for Dos on here and set up a DE 4.53 session and play to your hearts content in remaking your dummy menus in the real deal. You have a 30 day free trial which should give you all the screenshots you want. If you need it for longer just let us know and we can extend it.

DataEase 4.53 menu just now in the proper colours... ;-)

https://www.dataease.com/test_article_view/?ArticleID=00124&field1=00124

...

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

Written by: DataEase

DataEase Mainpage