Simplicty and flexibility!

-

Visitors: 17,769,555

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 638 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,947 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!

06/08/26 18:39:24

Re:New release of LE9 17/0726

downlpaded installed cheked ... 7342 still

...

Product:

Written by: Ihor Zakharchenko

06/08/26 09:49:33

New release of LE9 17/0726

Hi, all! Just got 7441 … but the downloaded file is 7342.exe … suppose it is 7441 nevertheless … the question in advance then … my license key as always . Thx a lot ! Glory to DataEase Team ! 

...

Product:

Written by: Ihor Zakharchenko

30/07/26 17:52:36

Re:One thing I don't understand, why you even need the data-entry values?

old good de 4.53 db with sequence from 1 got strange behaviour in table view and the keyboard tricks of fujitsu siemens laptop / thx for emergency aid nevertheless. Glory to DataEase team!

...

Product: LegEasy 9 Developer

Written by: Ihor Zakharchenko

29/07/26 09:33:02

One thing I don't understand, why you even need the data-entry values?

define "newnumber" number .

for SequenceStore with Name = data-entry field1 and data-entry field2 not = "yes" ;

newNumber := CurrentNumber + Increment .

modify records

CurrentNumber := newNumber .

list records

newNumber .

meaning this >>> with Name = data-entry field1 and data-entry field2 not = "yes" ;

...

Product: LegEasy 9 Developer

Written by:

28/07/26 14:46:51

Re:What is the best way of making a sequence?

Download Sample




Obviously the standard Sequence field but if it was that simple I guess you wouldn't have asked.


There has been a lot of "fixes" to the Sequence field (sequnce from 00001) over the years and confidence in the functionality have taken a beating.

We use it all the time but mostly just to get a "unique" ID for reference in lookups etc, rather than a completely guaranteed squence.

In the attached sample we "discuss" some ideas and ways to do it and we also showcase how you can use ExecDQL both as a function, inline and in a combination.

The sample is just for ideas and inspiration and you have to finish off how you want to use it yourself based on what is important.

We have a simple example that simply pick the Sequence from a table on load and update the value back immediately. This will make holes in the sequence if you don't store but you will never get two records with the same sequence.

We have one sample that use highest of in an execdql and update on save and another that use the sequencestore table as the first but run a ExecDQL "function" and update on Save again after having picked a "temporary" sequence on load.

Have a go and use it as you please.

...

Product: LegEasy 9 Developer

Written by: DataEase

28/07/26 14:44:19

What is the best way of making a sequence?

Quick question: In one of the LE9 application, I wanted to generate a 5 digit sequence number on a network with multiple users. What is the safest way to do this? so we don't duplicate or even skip numbers

...

Product: LegEasy 9 Developer

Written by:

24/07/26 13:38:24

Problem with EURO in DataEase.

But the ??? problem is ongoing and despite all the changes to the region settings in Windows 11, I still cannot get the ??? symbol to display properly. I also cannot get it to export to a .csv file. I will keep trying different settings. I did try the Chinese suggestion but no joy.

I now have another anomaly in DE8 in that the date setting of 00/00/0000 has now reverted to 00 00 0000. The date format 00/00/0000 was working fine up until a few days ago and now it doesn?t. Any ideas?

...

Product: Dataease [{8}]FIVE

Written by: jm@databiz.ie

24/07/26 13:38:52

Re:Problem with EURO in DataEase.



As you can see from the text in the orginal message, the character set on the DataEase under this website use character page 850 which doesn't have the EURO sign.

However, this can be remedied.

Open Control Panel (the good old fashioned one and not the Windows 11 Settings cr..p.



when this is done (a restart is to be recommended before one assume it doesn't work, but on my WIndows 11 it worked without a restart).

Then simply edit the RDRRxAAA.INI (the Applicaiton Settings in the Application Catalogue (you can edit the DataEase.inI to if you want to have this for all applications all the time).



858 is the PC OEM (updated) that replace the old 850 that does not have EURO sign.

The problem with no seperators in date is also in your Windows settings.

...

Product: Dataease [{8}]FIVE

Written by: DataEase

21/07/26 17:41:30

Re:Searching in text.

On a general note searchin gin DQL or in code can be done with much more precission buy using StringFind() and one can even search in all the data in a table with DEOS("@Record").

StringFind("StringToSearch","TextToSearchFor")

StringFind("This is a test","test") .
retval := StringFind(FieldToSearch,Search) .
StringFind("Hello World in the world", "world", 0, "exact") return 19
StringFind("Hello World in the world", "world", 0, "count") returns 2
StringFind("Hello World in the world", "Mars", 0, "count") return 0
https://www.dataease.com/dg3_HelpView/?PageID=1030...

https://books.dataease.com/viewdocument/?BookPrefi...

@Record
LE9
StringReturn all data from a record as one string
Paramters
- Sepearator | a sepearator that will be put in between the fields. Default is none.
Ex. DEOS("@Record") will expand and return all data from current record

You can for instance do:

For Mytabel with StringFind(DEOS("@Record"),data-entry search,"count")>0 ;
list records etc

...

Product: Dataease 9 Developer

Written by: DataEase

21/07/26 14:25:18

Re:Problems when searching using asterisk and tilde

Hi Pete.

DataEase utilizes three primary wild card characters for database queries and data filtering: 

  • * (Asterisk): Matches any number of characters, including zero characters.
  • ? (Question Mark): Matches exactly one unspecified character.
  • ~ (Tilde): Serves as the phonetic sound-alike operator for Soundex matches. 

    There is no such limittation for ^ but that is the agreed character for power in a lot of programming tools.

    I assume that you use this in a text capacity i.e. not for programming but for illustration? 

    like 2TTr or TTr^2.

    Above I've simply  used two capital T's to form TT which both code wise and lookwise is very close to what you want to achieve as I surmise that TT or even tt is not a common occurnece in a formula anyway?
...

Product: Dataease 9 Developer

Written by: DataEase

20/07/26 14:42:50

Problems when searching using asterisk and tilde

I am using Version 9.0.0.7342.

I am converting a system that uses the mathematical symbol for pi.

I decided to use the tilde (~) instead.

I have found that the tilde can be used in place of the asterisk when searching in a file i.e. Using "t*" for my search criteria is the same as if I use "t~".  This also gives erroneous results when the tilde is used in procedures.

I am now thinking of using the ^ symbol, unless anyone knows why I should not or can suggest a way to incorporate the mathematical symbol for pi.

...

Product: Dataease 9 Developer

Written by: Peter Birney, PB Associates

30/05/26 07:59:13

Re:Re:Re:Re:Re:Re:user directory open error

ps. I’ve tested … nevertheless . Also I’ve ancient giant tower with win95 & de4.53sql russian … and Microsoft lumia 950 with dosbox &de4.53sql russian ..and the first smartwatch Samsung gear 1 with dosbox & de4.53sql russian . English de4.53 is with me for sure . All works … the main problem as always was is and will be in … is is os ;) but DataEase always was always be excellent . Thank You all dear friends 

...

Product: LegEasy 4DOS

Written by: Ihor Zakharchenko

29/05/26 05:57:04

Re:DatAI?s

Earl Wertheimer Holy News on Windows 10 32 bit is just in time! Thx s lot, dear Earl

...

Product: Not product specific.

Written by: Ihor Zakharchenko

29/05/26 05:52:00

Re:Re:Re:Re:Re:user directory open error

hi! And DE4.53 was the only true AI from the very beginning of DataMaster AI epoch ;)

Thx for The Holy News ! Glory to DatAIs Team nevertheless! 

...

Product: LegEasy 4DOS

Written by: Ihor Zakharchenko

28/05/26 21:26:25

Re:Re:Re:Re:user directory open error

I added the TOUCH.COM program to all .bats running DataEase.

It just resets the datestamp on USERFORM.DBS whenever our timezone changes for Daylight Savings Time.

Touch.com USERFORM.DBS /T:3:14:16

...

Product: LegEasy 4DOS

Written by: Earl Wertheimer

28/05/26 21:21:37

Re:Re:Re:Re:Re:Corrupted DE 4.53 FORM

DataEase 4.53 and 5.53 work fine natively on Windows 10 32-bit.  

I've still got clients in production ;-)

...

Product: LegEasy 4DOS

Written by: Earl Wertheimer

10/05/26 17:01:35

DatAI’s

Hi All!

Playing with different AI’s up to blockbusters generations I’ve found that their main idea copied from DFD … forms and DQLs creating … For sure modern  textual “prompts” is not faraway from ancient coding in C or Basic etc.  BUT generating a result from prompt similar to form and dql constructing in DOS environment.

So the question is 

What new DataEase will propose instead of making prompts ? 
we have a lot of different data and telling by voice to DataEase what to do ? No direct thoughts transition for sure … still .

It is not a future … it had been done from the very beginning by Gupta and their semicode already.

Glory to DataEadr team nevertheless ! 
thank You!

...

Product: Not product specific.

Written by: Ihor Zakharchenko

14/04/26 04:31:48

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:DataEase access

u r welcome nevertheless . yup... The first and the only language on the planet  before Babylon tower development  is money. I need 7.2 legacy download working ;) Thank You very much! 

...

Product: DataEase for Windows 7.x

Written by: Ihor Zakharchenko

13/04/26 17:41:07

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:DataEase access

Thank you for your message. I appreciate that English may not be your first language. However, I am sorry but I don't understand your last two messages.

To confirm: my DataEase 7.2 has been working normally since I updated the error-prone update to Windows 11, without any changes to the DataEase software for the last 14 years. 

...

Product: DataEase for Windows 7.x

Written by: Anthony Kravitz

13/04/26 17:14:38

Re:Re:Re:Re:Re:Re:Re:Re:Re:DataEase access

It is hard to hack old apps … so You have evmove.com , Evdat* even … 

...

Product: DataEase for Windows 7.x

Written by: Ihor Zakharchenko

DataEase Mainpage