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 its scary with so many hidden Ifs and omls" hidden all over the place inour program , plus Im not sure if I will be ab...
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...
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 unfort...
Re:Change Text Colour
Download SampleWritten by DataEase 28/04/25 at 11:53:24 - 4 people have commented. The newsest comment is 5 days old.
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
...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!
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 generat...
Two reports to one pdf file
Is it possible to combine two different reports to print to one pdf file?
...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
...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!
...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!
??????? ???????!
...Re:Re:Re:Calculating Number of Months
not bad
...Re:Re:Re:Re:Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!
Written by Ihor Zakharchenko 21/03/25 at 12:20:34 - 11 people have commented. The newsest comment is 17 days old.
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 ...
...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
Written by Suzanne Michelle 20/03/25 at 15:38:26 - 3 people have commented. The newsest comment is 44 days old.
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?
...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) W...
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
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 S...
Re:I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!
Written by DataEase 19/03/25 at 23:43:27 - 11 people have commented. The newsest comment is 17 days old.
I'm an old, old, old DE user (4.53? I think) ... I need some menu screen shots please!
I am doing a legacy app retrospective for my development group at NYC Transit. "My" application started life about 30 years ago in DataEase, is now in Oracle, and is winding down, being replaced by another application. I actually have all my DE code /...
Re:Re:User view Toolbar in Design Time
Hi, all ! The forum activity and order to fix things weve saw earlier indicates in new DE download soon … thx a lot! Glory to DataEase team!
...Re:User view Toolbar in Design Time
Written by DataEase 06/03/25 at 06:59:48 - 2 people have commented. The newsest comment is 59 days old.
User view Toolbar in Design Time
Written by DataEase 06/03/25 at 06:56:32 - 2 people have commented. The newsest comment is 59 days old.
Re:Problems with Toolbars etc. disappearing
Catalog.html
Whats new shouldn?t do anything to your overall settings but the settings in DataEase is a ?mess? after years of moving things around ;-)
The...
Problems with Toolbars etc. disappearing
I got the What's New app running and found it useful—thanks!
However, I'm not sure if it has changed a setting on my system. Since using it, I no longer have window controls on form windows. The...
Re:Re:Re:Re:Re:Re:Re:Re:Difficulties installing on colleagues workstation
It's any DataEase user. When in Developer, I can open any form but when I open a menu, it hangs again. But the same menu is used on every body elses PC. When I logged the user out of the PC and used another user, it loaded fine.
...Re:Re:Re:Re:Re:Re:Re:Difficulties installing on colleagues workstation
If its the DataEase users when you login to DataEase it kind of doesn't make sense at all. I would simply create a new user for him in DataEase rather than spend any time trying to figure it out.
If its the network user then there is some acces...
Re:Re:Re:Re:Re:Re:Difficulties installing on colleagues workstation
Yes on one PC. Today I uninstalled both versions. Then logged the user out and logged in as a different user. Installed and it worked. Went back to the original user and it doesn't work.
...Re:Re:Re:Re:Re:Difficulties installing on colleagues workstation
On one computer only?
You are talking about inside DataEase like user being medium3 or low2?
Re:Re:Re:Re:Difficulties installing on colleagues workstation
Developer works but wont load with a non high security status account.
...Re:Re:Re:Difficulties installing on colleagues workstation
So works on most machines but not one... Hmmm.
Is there anything different?
Different Windows etc?
Not working at all is normally easy, doesn't work in one setting is hard... Does it work in Developer on this particula...
Re:Re:Difficulties installing on colleagues workstation
Thank you. For clarity, I've used DataEase since 1989 and set-up many applications. We have the player running on everybody's PC and in the user detail, is the start-up Document, in this case M_Main. It runs for every user without issue.&n...
Re:Difficulties installing on colleagues workstation
The player.exe is a work in progress and the one that is shipped with the Developer is basically a preview of application tool rather than the full monty.
We intend to include a "catalog" type startup page for Player too, but more like an appli...
Difficulties installing on colleagues workstation
We are running LegEasy6835 and on a new user machine, we can't log her in. I can download developer and it will log me in as Admin. When I try and login as a user, it doesn't open. I run the current version of player, and the application d...
Re:Calculating Number of Months
Written by DataEase 17/02/25 at 16:27:41 - 3 people have commented. The newsest comment is 44 days old.
Calculating Number of Months
Can you please assist me with a formula to calculate number for months say from 01/05/1999 to 31/08/2025
...Re:Re:DE9 Email configuration.
Every major SMTP provider is changing to OAUTH2 which to be honest is a nightmare...like most "secure" things are.
The idea is that servers is supposed to authenticate each other and only receive/forward mail from certified servers.
SMTP...
Re:DE9 Email configuration.
Hi,thanks for your help on this one. I've now got it working, I abandoned the yahoo email settings and used my own BT email instead. Bingo! it all started working. I'm looking forward to the new email setup when ts ready. <...
Re:Catalogue not shown
Some further digging in old documentation we found that there is another way to tell the WebView what emulation you want. Its a M...
Re:Re:Re:Re:Catalogue not shown
The problem is that the WebView object used in LE9 and many other tools is based on IE11. WebView2 which we use in DE10 is based on edge.
We have retained the IE11 object in LE9 simply because its much easier to work with for our users th...
Re:Re:Re:What is New in LE9 sample.
GREAT! thx a lot. GLORY TO DataEase team!
...Re:Re:Re:Re:Export Group/Count data to text file
undoubtedly new DE will solve the problem NEVERTHELESS
...Re:Re:Re:Re:Catalogue not shown
Hi all. It is better TO wait for A new RELEASE of DE ... undoubtetly
...Re:Re:Re:Catalogue not shown
Another Windows update and the same thing occurs.
I am now using Version 6835.
I perform the Windows update, go into LegEasy9, open a database and the same things occurs (See attached .png file).
I go into several different data...
Re:Re:Re:Export Group/Count data to text file
Doubt it will remove your error but it is convenient to include the column header with delimiter
.form header
Key`Count
.items
@f[1,1]`@f[1,2]
...Re:Re:Export Group/Count data to text file
Yes,
Below is the script I have tried. Thank you for responding.
for Applications ;
list records
Key in groups ;
Key : Count .
export to "C:\Users\RainsJC\Desktop\Audits\Keys.txt" .
.form header
.items Written by Bolt-on-Trailers 24/01/25 at 01:13:04 - 4 people have commented. The newsest comment is 97 days old.
Re:Export Group/Count data to text file
Does the DQL have " .end " in the last line?
...Re:LE9 .6835 Change in DQL editor type-ahead search and Tab behaviour?
Anyone else seen this?
...Export Group/Count data to text file
Hi All,
Can I export the Group and Count data to a text file? The following script gives me the error in the attached file. I'm not sure how the script for the required TableView Name (see attached) should appear.
for Applicat...
Re:Re:What is New in LE9 sample.
Scroll down to @EmailSend and you will see how the function works.
Re:What is New in LE9 sample.
Thanks for including the whats new files I think I'm on the right lines however even the whats new examples assumes the Email Configuration is valid and this is where I think I'm going wrong. Is there a way I can tell if it is valid ? Do you have a da...
What is New in LE9 sample.
Here is the latest increment of the What is New in LE9.
You can download and use that to test these things.
It is b...
Re:DE9 Email configuration.
Hi Eric.
We are amending the email function as so many SMTP servers now demand a more secure authentication due to spam etc. SMTP is a fire and forget protocol which is a big problem as people can actually very easily use any server to forward...
DE9 Email configuration.
Hi, I'm trying to email pdf documents directly from Dataease. I have set the email configuration to a yahoo account I created for the purpose. I have an icon with a blue spinning gear which I assume means something (hopefully good). I was h...
DIW create utility
Attached is an example app containing a generic utility to automatically create a DIW script and copy all required files to a folder.
This is useful for where one or more users are working on one or more DEV app copies to be ab...
Re:Re:help please
ok. thx a lot and best wishes for all and Glory Slava to DataEase team! <3
...Re:help please
its been fixed. Maybe not put license keys like this on an open forum...
...Searching for a job opportunity
Hello, my name is George and I have been authorized directly by Ulrik Jacob Hoegh-Krohn to post this thread on the forum.
I'm very experienced when it comes to developing in DataEase; I started working with the application since March 2013 when...
LE9 .6835 Change in DQL editor type-ahead search and Tab behaviour?
In LE9 .6835 in DQL editor pick list the type-ahead context search will only find the first character.
In previous versions in the DQL editor Tables pick list a table named "ABCDE" can be found by typing 'abc' .
Now the auto...
Re:Re:Understand index and virtual field use in DataEase
ps. 1990s practice with field indexes was described in volume 2 of de 4.* manual devoted to dba & applications development. limitations were up to 8 indexed fields on a single form. only necessary fields were to be inedexed. new recommendations he...
Re:Re:Re:Re:DE8.5 Textout UTF-8 format
Hi, Sam! Very useful case! Thx. May be A and B are different a bit ? What about text format of C which is the combination of A and B ? Thank You.
...Re:Re:Re:DE8.5 Textout UTF-8 format
As noted in the initial post the server system locale settings were checked and nothing has changed.
User logon is via Published Remote App with Active directory credentials.
The system locale settings for the user session are se...
Re:Re:DE8.5 Textout UTF-8 format
Written by DataEase 22/11/24 at 12:23:04 - 4 people have commented. The newsest comment is 163 days old.
Re:DE8.5 Textout UTF-8 format
From 7.2.2 help
RDRRDAAA.INI
ANSI_CHARSET
ApplicationCharset= 0
DEFAULT_CHARSET
ApplicationCharset=1
Default for DE8.5 is ApplicationCharset= 0
Changing setting to ApplicationCharset=1 does not make a...
DE8.5 Textout UTF-8 format
We have a DE85 app that writes text files using textout / textoutln on a MS2012 server.
Up until 2024-10-30 the files created were UTF-8 format.
For some unknown reason as from 2024-10-31 the files are ANSI format.
Nothing was changed on t...
Re:Re:LE9 copy special FIXED
Thank you
...Re:Understand index and virtual field use in DataEase
thx. that was tested with dfd even in 1990s ...
blackouts due to the war impose low power consumption & high productivity of software here in Ukraine now...
...Understand index and virtual field use in DataEase
Indexes is mostly "abused" in DataEase. People think the more the better, but they will only work if used right.
As a general rule indexes will make searching faster and saving slower.
But...
DataEase will only use an index...
Re:Re:Re:Re:Re:Re:Re:Re:Re:Virtual server configuration
das ist fantastisch! what about of reindexing time in the case then ? for sure, DataEase isn't a simple mechanism and the golden rule of mechanics is not about of 7000000 records with amount of fields more than 1... thx a lot for the this amazin...
Re:Re:Re:Re:Re:Re:Re:Re:Virtual server configuration
The problems is always related to change. If you start of developing a system you will design it so it runs OK with the limitations you have at the time. Then when it goes slow, you will clean the system/delete unnecessary data, buy better hardware et...
LegEasy 9 Developer ver. LE9.6835 Released: 13/11/24
super speedy! thx a lot!
...Re:Re:Re:Re:Re:Re:Re:Virtual server configuration
agree, yup, this is not my personal opinion BUT! this is not old good days too. This is present day trend. SSD's productivities tends to RAM's ones.
Modern OSes are handling hardware equipped with wise chips and present day operating system...
Re:Re:Re:Re:Re:Re:Virtual server configuration
Ihor!
We have talked about this before.
You are entitled to your opinions etc, but we don't need it as a comment on every genuine request for help or information.
Please don't comment on posts about the good old days a...
Re:Re:Re:Re:Re:Virtual server configuration
Hi All!
For sure, no VMware, no windows, only DataEase OS, shortly DOS.
No disks, no files and etc.
enough is enough!
Only RAM ... a little ROM as a vintage device for museum purposes.
where are di...
Re:Re:Re:Re:Virtual server configuration
Re:Re:Re:Virtual server configuration
When you run DataEase on a shared file server the "challenge" is file access and throughput i.e I/O.
So the main problem is disk access, not memory etc.
So quick disks, controllers etc. is what is the crux of the matter.
it...
Re:Re:Virtual server configuration
Hi and thank you for the feedback .
Are there any recommendations running Dataease on a Virtual server? reserving cpu and memory , exposing the VM to the physical host hardware as much as possible?
I can understand the key is i...
Re:Re:Read DataEase Files
There is no tool that open them and export the content as such.
We have a service on our shop where we export all the data in an application.
Re:Read DataEase Files
DataEase for Windows 5.x and before
...Re:Read DataEase Files
DataEase for Windows 5.x and before
...Read DataEase Files
Hello please could someone recommend the best solution for reading one of these files? this is for an application used in the 1990's - we want to move it to SQL.
...Re:Re:Virtual server configuration
IT departments ..those were mentioned in the earlier discussion by Sam Bird about of LE9 productivity
as the ... crowd of sysops & sysadmins from ancient IBM360 times ... where is windows nightmares were seeded from.
as to N...
Re:Re:Catalogue not shown
I have just re-booted my pc and it now works as expected.
Previously, after I had downloaded the latest version I had gone into two different databases.
In each case, I had only to enter a name but no password.
In each case agai...
Re:Catalogue not shown
This is not related to the latest version.
Is this on all applications, what if you create a new one.
Did this work before you installed the latest version?
Is this a new device?
Re:Virtual server configuration
The key is in the VIRTUAL bit.
There is nothing you can do on the DataEase side of this, it is all on the VMWARE side of things. Obviously virtualizing a server means that you add a layer of processing on top of the hardware and hence loo...
Re:This is fixed in Build
Hi, Sam
well, 7814 became 6815 then 6817 . thx.
but what was implied by "??" in the sentence ... was that fixed at last ? Your example with 3 fields in relationship and SQL server ...and LE9 productivity was not presented here still....
Re:Virtual server configuration
DataEase version 8.5.1.2674
...Virtual server configuration
Hi DataEase
we moved from a physical server window 2012 to a virtual server with these characteristics:
The VM sits in a clustered VMware environment DRS enabled.
Vcenter version 7
ESXI version: VMware ES...
Catalogue not shown
I have installed the latest version, 6817, downloaded today.
When I run it, it shows the list of databases. I then select one, enter the name/password and I am presented with a blank screen, with 'Catalog' shown at the top. If I go t...
This is fixed in Build #7814 31/10/24 ??
and where is Build #7814 31/10/24 ??
but many thanks for Build #6815 31/10/24 !!
Glory to DataEase team nevertheless..
...Re:Re:LE9 copy special FIXED
copy&paste works, just downloaded
Re:LE9 copy special + FIXED
This is fixed in Build #6815 31/10/24 ??
...Re:Re:Re:Re:Re:Re:Re:Re:Re:LE9 DQL performance advice?
Our journey started with DataEase 7.1 and the job has been to improve and fix issues with that as a baseline.
There might be a lot of things that works better or mostly just different in DFW 6 compared to DFW 7 onwards but that would be neither...
Re:Re:Re:Re:Re:Re:Re:Re:Re:LE9 DQL performance advice?
Hi, Sam
as I've said already about ms crowd of sysops & sysadmins ask the doors of law about their comments on the issue mentioned by You...
Also I've demonstrated the frustrating situation with using web browser in LE9 caused by mustd...
Re:Re:Re:Re:Re:Re:Re:Re:LE9 DQL performance advice?
Any comment from Dataease support regarding LE9 issues with multiple field Relationships and queries?
...Re:Re:Re:Re:Re:Re:Re:LE9 DQL performance advice?
who knows ... I use the only method .. M: make one clear change and see what will be then think ...go to M )))) (loop until success)
as to me all recommendations are not to use Chromium OS or Chrome extensions to execute ms dos or wind...
Re:Re:Re:Re:Re:Re:LE9 DQL performance advice?
Hi Ihor
Been there, got the T-Shirt. Native SQL DML has no issues and DE6.53 has no issues.
Only found it with DE8.5. Have not tested that specific issue with LE9.
It may also be a difference in the OLEDB on MS2012 vs MS2008 OLEDB ?...
Re:Re:Re:Re:Re:LE9 DQL performance advice?
as a software & hardware tester with more than 40 years of experience with different architectures I propose to check that SQL DB with reliable native in the case SQL tools(as I did with .dbf using dBase in 1992)... and due to the lates...
Re:Re:Re:Re:LE9 DQL performance advice?
Will look at exec DQL going forward.
For now makes no sense to re-invent the wheel if the wheel is already working...... and the wheel is running magnitudes faster now.
The DQL performance Achilles heel in LE9 is multiple field Relationships...