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.
27/07/24 12:33:10 
LegEasy 9 Developer LE9.6709 Pre-Release 23/07/2024
Thx for it. Is it finally impossible to embed in *E9 different browser other than IE ? Playing games with strings in bing maps are great but we need to use apps not coding each bit in bytes ;) Create a Custom Map URL
...
Product: Dataease 9 Developer
Written by: Ihor Zakharchenko
14/07/24 11:35:25 
Re:Bing on the string
it is obvious that old reliable hardware and the same aged dos software are the best in the real conditions of WWIII in Ukraine now.
storing data from the battlefields or crashed by missile attacks ukrainian cities into simple but powerful DFD databases is the only solution there now.
.. those data will be used in modern *E9 apps..
in a safe locations
Amen
...
Product: Not product specific.
Written by: Ihor Zakharchenko
13/07/24 22:56:24
Re:Re:Re:Re:Re:Re:Re:de8 CRM sample
Excellent! Thank You very much!
For sure that is our turn to use those features like DQL for DFD in AI mode, sorry< Automatic Inserting> way not in usual symbol by symbol coding of the statements. naturally the form and fields design as in DFD too.
is that DFD mode of "coding" possible in *E9 to get for web oriented purposes, including whatever maps ?
thx
Glory to DataEase team!
...
Product: LegEasy 9 Developer
Written by: Ihor Zakharchenko
13/07/24 13:34:58
Re:Re:Re:Re:Re:Re:de8 CRM sample
You can use any weblink you want. This type of field just load an url that can be derrived in normal DataEase way. concat etc.
You also have memo webfields that resolve the HTML stored/computed in a field etc. but that is another story.
The only thing we did in the Google sample was to create a google URL with the post code etc. So its very easy to do.
The map has nothing to do with the field type, it is just a way to illustrate the use.
concat("https:\\mymaps.com?Postcode=",postcode) or something like that.
It will work with any map or any website/link etc.
We don't do the research or integration with any specific map/website, we simply develop the technology, show some simple samples and then we leave it to you to figure out how to implement it the way you want.
...
Product: LegEasy 9 Developer
Written by: DataEase
13/07/24 11:20:16
Re:Re:Re:Re:Re:de8 CRM sample
what about DuckDuckGo or even Yandex maps (vpn is needed in Ukraine now)
...
Product: LegEasy 9 Developer
Written by: Ihor Zakharchenko
11/07/24 17:13:06
Bing on the string
40 years ago I've started intensive succesful coding of Metaconta from ITT , an International Telephone & Telegraph supercomputer, from engineering console without any translator and display ;) DataEase 2,53 for Dos made me laizy in coding since 1989 ...
so CRM from DE*.5 on LE 9 6697 with Bing instead of Google Maps
(to be continued)
...
Product: Dataease 9 Developer
Written by: Ihor Zakharchenko
11/07/24 15:36:31
Re:Re:Re:Re:de8 CRM sample
still trying ti replace google string with bing ... please help to get correct final code to see the bing map instead of google one. thank You ..
...
Product: LegEasy 9 Developer
Written by: Ihor Zakharchenko
11/07/24 15:33:24
Re:Re:Re:de8 CRM sample
What is this supposed to mean?
...
Product: LegEasy 9 Developer
Written by: DataEase
11/07/24 11:50:34
Re:Re:de8 CRM sample
...
Product: LegEasy 9 Developer
Written by: Ihor Zakharchenko
11/07/24 09:48:14
Re:de8 CRM sample
This is an old sample created a decade ago and not included in LE9.
it was a quick thing we knocked together to showcase some of the new stuff in DE8 and as happy we are for the fact that you found it useful most of the techniques and methodology used in it has long since been improved and can be done much better in later version of DE8 like 8.5 and definitely in LE9/DE9.
The sample is completely open and anyone can "steal" or use any part of it.
DataEase is a development tool where the customer use it to derive their own solutions. The Google maps sample is there to show how one can integrate a website with an app, there is also pure WebFields where the content is rendered as a web page which is used for Editors, graphs or whatever the imagination will allow you to want to do.
We make the features available give you a taste of how you can use it but we don't put the limits on it and we very often is impressed by how some customers take advantage of the features in ways we hadn't even imagined.
That google maps have decided to not support IE11 anymore is their prerogative but the problem is that this become a problem for a DataEase developer.
I hope that if you use the CRM sample as rudimentary as it is you will have changed it quite dramatically already. I've used it as a template many times and as this previewing of maps is mostly just a demo thing without any real value in an address book I've mostly just removed it as I definitely don't need/want the message.
However if I wanted a map displayed I would simply take a quick "google search", find alternatives to Google Maps and test if they work in the IE11 object.
And many of them didn't as graphical stuff is one of the things that has gone "native" in modern browsers and hence if they use native functions that was not around in IE11 it won't work.
But who is most likely to keep backwards compatibility with a Microsoft browser that has been around for "Millions" of years?
Microsoft...
So the Bing maps works perfectly and most likely will work for quite some time before it get obsolete.
There is also plenty of offline maps engines that can be downloaded and use locally that will never be obsolete (other than the maps maybe being obsolete in themselves).
https://www.microsoft.com/en-us/maps
...
Product: LegEasy 9 Developer
Written by: DataEase
11/07/24 08:38:57
de8 CRM sample
thx a lot for le9 6697 08//07/24. we are using CRM sample as a template for mapping missile shellings .. it works a bit in 3d and 2d modes but for a moment then screen with browser option to download appears. what is appropriate alternatives to google maps are in the case. thanks in advance. Glory to DataaEase team!
...
Product: LegEasy 9 Developer
Written by: Ihor Zakharchenko
09/07/24 12:23:10
Re:Re:Re:Re:Re:Thank You very much!
we are very sorry again! may be it is due to our local version of English here in Ukraine not a London cockney for sure... no discussion at all. we got ms lumia 950 device with windows on board and it runs de4.53 EN like a russian missile x-101 crashed children's hospital in Kyiv yesterday. And we've started useless dreaming about *E9 from Microsoft Store on that device asking us to windows 11 update ...see the picture
...
Product: Dataease 9 Developer
Written by: Ihor Zakharchenko
09/07/24 10:25:09
Re:Re:Re:Re:Thank You very much!
THE CRM sample is not part of LE9 but DE8 and you can use websites.
It is Google Maps that has decided not to support IE11, most websites still work in IE11.
The Maps connection in the CRM sample was made a long time ago and simply to showcase how one could integrate web content in a document.
This forum is again not a place to discuss design decisions that is ours to make but to exchange ideas and ask for help from other users about how to achieve things with DataEase.
We could start a big discussion on why for a lot of things but that is an internal discussion we have at DataEase and not something we do in an open forum.
We develop products for a wide group of users and our main objective is to make the functionality we make available - usable to the majority of users.
...
Product: Not product specific.
Written by: DataEase
09/07/24 09:43:36
Re:Re:Re:Thank You very much!
thx. any how to , sample like that CRM without using web sites ? one more question, specific device usage case. it goes about windows application store...so is it real hope toget LE9 from windows store ? thank You very much!
...
Product: Not product specific.
Written by: Ihor Zakharchenko
08/07/24 15:19:39
Re:Re:Thank You very much!
LE9 is using IE11 object and there is no way around that in this version.
There is a million good reasons for using IE11 over Edge/Chromium in DFW the main reason being that this is not for websites but for menus/images/functionality. If you want to use the API jsBridge() that allow you to talk to DE directly then the advantages of IE11 over Edge is enormous as Edge is asynchronous while DFW is synchronous and so is IE11.
...
Product: Not product specific.
Written by: DataEase
02/07/24 11:01:29
Re:Thank You very much!
...
Product: Not product specific.
Written by: Ihor Zakharchenko
02/07/24 10:49:00
Thank You very much!
"The forum is solely for asking other users for ideas on how to do things in DataEase."
we are sorry too. Thank You sincerely. It is still impossible to avoid IE issue with maps in CRM sample in the latest L9 ... but we shall overcome ..altogether for sure.
...
Product: Not product specific.
Written by: Ihor Zakharchenko
02/07/24 09:30:18
Re:Re:Re:Re:for those who tired waiting DE9
I'm sorry but we have no knowledge of these laptops and to be honest running software from the last century is not our main priority. If you can get it to work with Windows 3.11 and DFD 4.x feel free and you don't have to worry about licenses etc, but this is not something we will look into, publish or support. Good luck!
And for the future the forum if you have a request for DataEase don't use the forum to reach us, but send an email to contactus@dataease.com or use the contact page.
The forum is solely for asking other users for ideas on how to do things in DataEase.
...
Product: Services
Written by: DataEase
02/07/24 07:35:44
Re:Re:Re:for those who tired waiting DE9
that means we have to know whether is it possible to install original DFD 4.53 EN on that laptop with Windows 3.11 onboard or not. We have no possibility to buy both the software & hardware mentioned here in Ukraine due to the war now. Please help. Thx in advance. Glory to DataEase team !
...
Product: Services
Written by: Ihor Zakharchenko
02/07/24 01:24:14
Re:Re:for those who tired waiting DE9
sorry, if that was looking like ads. simply windows 3.11 on that laptop may help to manage with an old DFD application to use it in LE9 ... excuse me< but we need that hardware for our military purposes. is it a way to get those win3.11 notebooks with DFD 4.53 English for we have severe conditions with logistics during the war. thank You.
...
Product: Services
Written by: Ihor Zakharchenko
Register
Sign In
