DataEase for DOS DQL Manual
With the "Re-Launch" of DataEase for DOS through LegEasy4DOS the need for a refresher in old syntaxe for commands and functions has returned with a vengeance.
Almost everybody has been able to keep track of their old applications but not as many has been able to keep hold of the manuals etc.
DataEase for DOS is so old that the manuals has never existed in electronic form.
But as part of our LegEasy program we have now dug up and old set and you can buy the DQL Manual in our WebShop for download.
A small preview of what you can expect is to be found under
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.
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.
10/10/24 20:59:16 
Re:Re:Re:Re:Browser needs to be updated
is it possible to get le9 /de 9 working with chrome browse soon ?
...
Product: Not product specific.
Written by: Ihor Zakharchenko
09/10/24 19:00:25
Re:How to check 'password' and make sure it can't be seen.
Download Sample
Please find enclosed simple sample that show you you can use different SetClass() functions like SetLabelText(). SetStyle(), SetFocus() etc. to achieve your goal...
We use white on white to hide the input in the field and then we have a virtual field (hidden in manip with SetState) that look up the value from My Users and another virtual field that check and enable/disable the login button etc. It also use SetFocus() to set focus to the login button, and use SetLabelText() to change the text on the button and the message label etc.
In LE9/DE9 you could have done all this quite a lot more elegant but hey ho ;-) This is not that bad...
...
Product: Dataease [{8}]FIVE
Written by: DataEase
09/10/24 18:59:01
How to check 'password' and make sure it can't be seen.
I need some help please , I want a Cashier to approve a surplus/shortage with their password, but I need the password to hide after it was entered or while they are entering .
Then I need to check that the password is valid.
I thought of using SetState , and it works and hides the password entered , but then it does not check that the password is correct , as of the password was not entered
Please help me
...
Product: Dataease [{8}]FIVE
Written by: charmaine smit
07/10/24 18:43:54
Re:Re:Re:Browser needs to be updated
...
Product: Not product specific.
Written by: Ihor Zakharchenko
07/10/24 16:14:01
LE9 CRM sample MS Bing and Open AI chatgpt
Open AI got fantastic investment recently
so the question is how to make MS Bing be friend of chatgpt site ;)
this is about how to make DataEase be DatAIs for ukrainian armed forces
...
Product: LegEasy 9 Developer
Written by: Ihor Zakharchenko
07/10/24 15:39:31
Re:Re:Re:Re:DE4.24U
à la guerre comme à la guerre
don't worry
somebody made humans without admin level access ... the pair of humans had tried to get pswd from serpent ... access denied ;)
humans made AI the same way ;)
simply make DatAIs for the chief of ukrainian embassy in London to get access to funds mentioned above ;)
winners are defined in shadow even before a competition in price&quality already ;) .. but try
DataEase was in NASA , state structures worldwide even in DOS environment since 1980t ;)
Good luck!
...
Product: DataEase for Windows 5.x and before...
Written by: Ihor Zakharchenko
07/10/24 11:49:30
Re:Re:Re:DE4.24U
And Unicorn's exists ;-)
The moment we succeed with AI as people believe it is working we obsolete humans.
The IT industry love to come up with suggestive names to make people believe that "all their wishes have been answered!"
AI as Crypto (block-chains) are mostly beneficiary to people that sell computations i.e. data-centers and hardware producers. In many ways it is a waste of computer power to make people think that there is gold at the end of the rainbow.
First of all, there is nothing intelligent about AI so the name is wrong. Intelligence is in many ways counter intuitive and computers don't have the ability for either and never will.
Computers have outperformed humans from the day they were invented - it is why they were invented - but only at repetitive tasks.
Yes, you can get a computer to make you a new Word or DataEase by looking at the code, you can also get it to remove obsolete code etc, and optimise the product but you can't get it to make a better version of either.
And if I'm wrong we have all lost because then I'm out of a job and so are you.
...
Product: DataEase for Windows 5.x and before...
Written by: DataEase
06/10/24 12:25:53
Re:Re:DE4.24U
Thus we need a tool fully AI without any coding by customer!
...
Product: DataEase for Windows 5.x and before...
Written by: Ihor Zakharchenko
05/10/24 12:28:28 
Re:Re:Re:Re:Re:Re:Re:OML show() / hide() does not carry through to printout
old good DQL for DFD kept not only right spelling even when level High was switched ...
but !
Semantics was controlled too
Not only syntax ;)
so AI was invented by Gupta in practice in 1980's
and that was DQL for DFD !
...
Product: LegEasy 9 Developer
Written by: Ihor Zakharchenko
05/10/24 11:33:25
Re:Re:Re:Re:Re:Re:OML show() / hide() does not carry through to printout
Ahhh... didn't think of this. Kind of like a glass, it only work if its the right way around ;-)
The rule is that you can make things "more" secure with programming, but not the other way around. This only work on the GUI control anyway and does not play with the Read Only functionality which is prism based.
All this is "second" nature for DE8 programmers as we have completely moved away from necessary fields and validations etc.
It is really annoying to get this feedback on save rather than when you do the mistake, and also the way its presented to the user is annoying i.e. dialogues they have to accept etc. Data-integrity is better controlled with a DQL checking the fields you want to filled in on save and then highlight the offending fields with a legible error message in a label (SetLabelText) combined with SetStyle to highligh. You have complimentary GetValue() etc. that you can use to get the field values in controls. Am ExecDQL run from a form will have the context of that form so one can just pick the values out of the form and set them back, style them etc.
In LE9 you can call execDQL from a DQLstore table with simpy name or number ExecDQL("@DQLName" etc. or ExecDQL("#0001"
The DQL table need to be named in the RDRRxAAA.INI file with corresponding fields if not default.
You can also write ExecDQL in fields (lookup or anylookup), labels, in files or directly on a button. So you can make a button saying:
Delete record in table etc. or any other update/processing.
From next version onwards DataEase will be completely "Headless" and any GUI can be used on top of it. FRM will be replaced with HTML/Javascript (Chromium). Then you can make forms native, as mobile apps or web sites.
...
Product: LegEasy 9 Developer
Written by: DataEase
05/10/24 10:09:38
Re:Re:DE4.24U
...
Product: DataEase for Windows 5.x and before...
Written by: Ihor Zakharchenko
05/10/24 07:27:35
Re:DE4.24U
I am a current C#/SQL software developer who used to work for a DataEase distributor in the 90's. I am pretty sure 4.24 applications are the same as other 4.0 apps. I wrote the software package called DEAssist back in the day.
...
Product: DataEase for Windows 5.x and before...
Written by: Datadude
04/10/24 21:48:57
Re:Re:Re:Re:Re:OML show() / hide() does not carry through to printout
Thank you for the SetApp sample
fyi - Virtual field derivation was used - not OML
if(OrderNo = 1, if( OptionIND = 1 and RadioOptions = OptionA, SetState("ItemDesc" , "Disable") , SetState("ItemDesc","Enable")), SetState("ItemDesc" , "Disable") )
The issue was not in the SetState function, it was is the context of use.
SetState Enable / Disable only applies if the original form Field definition is set to allow entry.
SetState("ObjectName", "Enable") will not enable entry on a field if the Owning Form field definition is set as 'Read Only'
Thank you - sorted
...
Product: LegEasy 9 Developer
Written by: Sam Bird
04/10/24 18:38:07
Re:Re:Re:Re:OML show() / hide() does not carry through to printout
tune DataEase please ASAP
we have to eliminate all software related to aggressor here due to modern laws
this is great market ...but ... the country is 100% paradise for corruption
have a nice weekend too
...
Product: LegEasy 9 Developer
Written by: Ihor Zakharchenko
04/10/24 18:08:40
Re:Re:Re:OML show() / hide() does not carry through to printout
99% of coding mistakes (and sometimes the hardest to see/find) are spelling mistakes...
have a great weekend.
...
Product: LegEasy 9 Developer
Written by: DataEase
04/10/24 17:02:34
Re:Re:OML show() / hide() does not carry through to printout
"1. You need to accept that you are the one that came late to class"
Sam, Dear Friend means only the LIFO principle and nothing more ...
no labLEs instead of labELs here nevertheless
... living in the wall (c) ;)
...
Product: LegEasy 9 Developer
Written by: Ihor Zakharchenko
04/10/24 16:45:15
Re:Re:Re:Re:Re:Re:OML show() / hide() does not carry through to printout
Here, Teacher
SetLableText("objectTestButton","TestButton")
...
Product: LegEasy 9 Developer
Written by: Ihor Zakharchenko
04/10/24 16:32:02
Re:Re:Re:Re:Re:OML show() / hide() does not carry through to printout
As tests go, they need to be completed... ;-)
What was the problem?
...
Product: LegEasy 9 Developer
Written by: DataEase
04/10/24 15:43:57
Re:Re:Re:Re:OML show() / hide() does not carry through to printout
this is the screenshot simply and nothing more.
no comments even
only pics
we have funds enough to invest in You, Dear Friend!
Love You all, sincerely
...
Product: LegEasy 9 Developer
Written by: Ihor Zakharchenko
04/10/24 15:28:53
Re:Re:Re:OML show() / hide() does not carry through to printout
That is the test to see if anyone actually know how to program in DataEase.... There is no guarantee or refund on free samples. Figure it out ;-)
...
Product: LegEasy 9 Developer
Written by: DataEase
Register
Sign In
