Simplicty and flexibility!


Visitors: 14,227,120

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 - 3 people have commented. The newsest comment is 102 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

DE85- 100% control of the USER!

Download Sample

We got a request on the form about how to use Modal and switch between f...

Written by DataEase 19/08/20 at 14:32:40 Dataease [{8}]FIVE

Beta 33% 09.11.19 - A Dataease version fully built in - Dataease

The time has come and today we let the cat out of the bag - for the first time we let anyone outside our closet partner network see and play with DE9.

We call it Beta 33% but don't make that put you off. It is a fully working replacement for DE8.5 which was the first milestone we wanted to reach before we let it out.

However it is much more than that which you will quickly find out. The reason we call in 33% is because it is at this stage only 33% of our ambition for DE9.

So within these 33% you find all the functionality from DE up to and including 8.5 final with over a 100% new functionality partly revealed today and to be revealed and evenly spaced out increments over the next 3 months.

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.


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.

Start your own thread!

02/03/21 17:01:50

Table name already exist - Method to avoid this problem recursively

I return to a topic already covered both on the Forum and on your Blog.

Sometimes a wrong items is generated in the catalog file RDRRxAAA.DBM which causes the following error when the database is opened:

It has been repeatedly indicated how to correct the error but nothing on how to avoid generating it.

This error recurs periodically in the database for no apparent reason for the $DeStat_DQLInfo$ item which is a system table repeated many times in this file.

Obviously, by correcting the last item from 0C to 0F, everything is resolved.

So the problem lies in the product, how can I prevent this from happening all the time?


[DataEase 8.5]


Product: Dataease [{8}]FIVE

Written by: Marco Marchesi

12/02/21 11:05:23

Re:Re:Center the forms

LE8 which is the next version of DE8 will have a lot of new stuff inherited from Big Brother (DE9) but that is another story.[quote]

Got it at last! The reply to my question but in the different thread but itwas not due to me


Product: Dataease [{8}]FIVE

Written by: Ihor Zakharchenko

11/02/21 11:03:17

Running Applications on Cloud


When are we going to run dataease applications in your cloud solution


Product: Not product specific.

Written by: Godfrey

09/02/21 17:29:06

Re:Center the forms

Hi Per Ove.

Yes, definitely.

A lot changed over the DE8 project and still is. LE8 which is the next version of DE8 will have a lot of new stuff inherited from Big Brother (DE9) but that is another story.

In DE8 we focused on giving developers/users more flexibility to achieve more tailormade solutions compared to previous versions of DFW.

The function you look at is located in SetCurrent() which is part of the Set family of functions. (SetState(), SetColor(),SetStyle(),SetCurrent(),SetValue(),SetLabelText(),SetFocus(),SetVar() - I think I got them all.

You find them all in the Help section on this page.

The one you are looking for is: 
SetCurrent("WindowPos","C","C") -- Will set the current Window Centre/Centre.

If you always want this windows to be opened centered you can put it as derivation on a virtual field and combine it with SetState("ObjectName","Hide") where ObjectName is the ObjectName of the field you execute it from. This way you hide that field. We normally call these fields "Manip" so the derivation of the virtual field Manip would be.


You can add any number of functions to this chain with + 

Obviously you can use this function to set the window anywhere ("C","C") is just a simple way of centering that save you from having to calculate where the left upper corner should be positioned to center the window.

SetCurrent("ActivateDE") -- Activate DE environment for GUI updating.

SetCurrent("ActiveDoc","DocumentName") -- Bring to front and activate Document
SetCurrent("ScrollTo","ScrollX","ScrollY") -- Force the active document to Scroll.
SetCurrent("@DefaultPrinter") -- Will set the Windows Default Printer.
SetCurrent("@Printer3","Hp LaserJet 4700") -- Will set The workstation printer 3 to HP LaserJet 4700
SetCurrent("WindowBorder","NoEdge") -- Will remove caption and border from current window.
SetCirremt("Size","ObjectName","100","100") -- Will set the size of ObjectName to 100 x 100.
SetCurrent("Move","ObjectName","Xpos","YPos") -- Will Move object to xpos, ypos.
SetCurrent("WindowBorder","NoEdge") -- Will remove caption and border from current window.
SetCurrent("WindowClass","Modal") -- WIll make the current window modal.
SetCurrent("WindowPos","C","C") -- Will set the current Window Centre/Centre.
SetCurrent("WindowSize","200","100") -- Will set the current window 200px wide and 100px high.
SetCurrent("WindowType","NorMax") -- will size the window to maximum size to fit in MainWindow.
SetCurrent("Statusbar","Off") -- Switch off the statusbar.
SetCurrent("Tabbar","Off") -- Switch off the Tabbar.
SetCurrent("Toolbar","Off") -- Switch off the Toolbar.
SetCurrent("Filemenu","Off","Keepline") -- Seitch off the FileMenu but will keep the white background.
SetCurrent("AllBars","Off") -- Will switch off File Menu/Toolbar/Tabbar and Statusline in Runtime.
SetCurrent("NewDatalink",enginename, databaseName, serverName, dblinkName) -- Create new DBLink
SetCurrent("DeleteDatalink",dblinkName) -- Delete DBLink
SetCurrent("RefreshDatalink",dblinkName) -- Refresh a DBLink and rebuild all tables etc.
SetCurrent("RecordsInForm", subformName, newNumberAmount) -- Change dynamically (in Runtime) the number of rows displayed in a subform
SetCurrent("ActiveWindow","WindowHandle") -- Switch active window to new window via Window Handle. Similar to SetCurrent("ActiveDoc") but more precise as it will deal with two or more windows with same document.
SetCurrent("CatalogDirty","yes"/"no") -- Will set flag to indicate that data in catalog is dirty or not. Used to reset after refresh of catalog, or to trigger a reload of catalog for any reason if changes has been do in application that need to be reflected in catalog list.

As you see from the list above you can do much more than position a window. You can change the class, look, size, activate a windows/hide it etc.

And this is just SetCurrent(), imagine all the things you can do with all the other ones and in combination with PRE 8 functions and all the Get functions which will give you current values.

Also take a look at DEOS() which is our "operating system commands". DEOS() is much expanded in DE9 but still very useful in DE8.

PS! Per Ove. It looks like you are running a very old version of DE8, download the latest from this site as there is bigger differnce beween 8.0 and 8.5 than between 5.x and 8.0


Product: Dataease [{8}]FIVE

Written by: DataEase

09/02/21 17:17:56

Center the forms

is there any solution to center the forms when i opening this in dease withouty to place this in center and use current windows placement in document:properties:windows placement -> currrent

per ove


Product: Dataease [{8}]FIVE

Written by: Per Ove Berg-Roren

04/02/21 02:32:36

Re:Re:Re:Re:Filtering records via a button in form view


Product: Dataease [{8}]FIVE

Written by: Barry Sweet

03/02/21 12:28:09

Re:Re:Re:Filtering records via a button in form view

Hi Barry.

Sorry for confusing you with the elaborate explanation of the illogic of the SelectionFilter() function.

RadioButtons use a choice list and in DataEase language they are represented by the value WITHOUT "".

Selection Filter("MemStatus=Member", "")
Is the correct way of doing it, if you look at the code on the buttons you will see this.

The reason we created the escape characters is so you can represent characters like " inside " " i.e. string within a string.

When you unzip the file you can decide where to put it, but if you just downloaded the file and unzipped it it will be in a catalog called RadioBox under your download catalog.

There is no username/password. It should start up directly with the correct form but if not, just hit enter in the login screen and it will do as prescribed.


Product: Dataease [{8}]FIVE

Written by: DataEase

03/02/21 03:03:05

Re:Re:Filtering records via a button in form view

Thank you for your quick response, I truly appreciate it. The radiobox solution worked as advertised. However, I am not having much luck with the button’s selection filter solution. I am not savvy enough as I do not have much experience.

MemStatus is the name of the radio box choice field which have three choices: Member, New Convert, and Visitor. I saw your discourse on the illogical workings of the Selection Filter as well as the simple solution to my issue – (MyRadioBox=.’Member.’”, “”) I also saw the escape characters but do not understand their relevance. In any event, I placed the following derivation in the Member button after selecting Selection Filter(“MemStatus=.’Member.’”, “”) and received a 401 Setting Selecting Filter. Selection criteria is invalid error message. I did not know that the apostrophe was a valid DataEase symbol. I was wondering if you could provide the exact formula including the escape characters, if needed, based on the parameters I provided, Based on that I can apply the formulas to the other buttons. Also, I downloaded the sample and unzipped the file but cannot find it. Is there a user name and password associated with it? I apologize for the imposition on your valuable time. Thank you.


Product: Dataease [{8}]FIVE

Written by: Barry Sweet

01/02/21 11:02:08

Re:Filtering records via a button in form view

Download Sample

You can of course add a choice (default maybe) that is None or something like that, as you as you rightly have pointed out can't deselect a RadioBox from the RadioBox itself.

However there is plenty of ways to do this.

The simplest way is simply to hit F6 (field clear) when the radiobox has focus. This is a little "Old style" as modern users want to click themselves out of everything rather than using function keys etc.

So in the attached example we also add a dblclicked event on "your" Radiobox so if you dblclick on it it will clear (just try).

The second question is how to filter your data from a button.

That too is rather straight forward.

Here we use the two functions SelectionFilter() and FilterClear().

Selectionfilter is a very powerful function that is quite underutilized, maybe because it is slightly illogical.

SelectionFilter(String,String) sets the filter as a string. It has as you can see two arguments so it would be logical to think that it would be the column in the first

and the value in the second...but no. It seems that it has two argument to circumvent the 255 boundry so you can set a 512 long filter....

So the filter is the combination of the two

Here: SelectionFilter("MyRadioBox=","Member") or SelectionFilter("MyRadioBox=Member","") or SelectionFilter("","SelectionFilter("","MyRadioBox=Member")

are all the same...yes, confusing.

An here we dodge a bullet, as the value is a choice and hence is to be represented in a derviation (filter) without "" but what if the field was text?

SelectionFilter("MyRadioBox="Member"","") is obviously not allowed/working.

Pre DE8 this would have been a serious nut to crack but luckily in DE8 we have escape characters so the solutio is simply.


Characters include is:

" = /'

CR = /CR (New line)

TAB=/TB (Tab)

We hope this helps.


Product: Dataease [{8}]FIVE

Written by: DataEase

01/02/21 04:25:51

Filtering records via a button in form view

I have a member’s form with a choice field (radio-box) which has three (3) categories: Member; New Convert; and Visitor. Is it possible to filter records from a button that will filter records, in form view,according to the option a user chooses? For instance, if member is selected then only those records that has Member checked will be displayed and can be searched.

Also, is there a way for a user to clear a radio-box choice field ? If not, then there will need to be an option to display all records or clear the filter from the button. It seem that once a user makes a selection in a radio-box choice field there is no going back unless the form is cleared.

Thank you in advance for your help.



Written by:

28/01/21 17:30:10

Re:Re:Re:Re:Re:How to get DE 9 prerelease to check and idea about DQL ?

Dear Sirs, there are no problems at all. What is "Legeasy 8" is  the only question being unanswered. I am the only who is staying with You amongst the crowd of peoples who were making money and other preciouss things using old good dataease for dos on our territory including the vast lands up to Japan. Tamara Korinkovskay  has made technical gift to me and went to Oracle Ukraine then ...

It is true I got an idea to check it with DE 9... but it came clear today that is impossible ... just after downloading 33% diamond set of tools. We need platinum. Will wait. But the hope is still with me get link for testing DE 9 behind those 33% of limited edition. For others got that chance ..why not me ?

Thank You for that link. just use fb or linkedin for getting my email. :)

and..nothing personal only business (c) a ...l ihor zakharchenko

Archie Roach - All Men Choose the Path They Walk

Some men are prone to misadventure

Questions of guilt aren’t always clear
Some men run from a fate they can’t avoid
All men choose the path they walk

Some can’t be faulted for their reason
Failing to justly intervene
Some men hide from the memories that haunt
All men choose the path they walk

Some men see everything through duty
Cast off responsibility
Some regret that their courage sometimes fails
All men choose the path they walk


Product: DataEase 9 Developer

Written by: Ihor Zakharchenko

28/01/21 15:43:40

Re:Re:Re:Re:How to get DE 9 prerelease to check and idea about DQL ?

Dear Ihor.

You are obviously frustrated and wish things to be differently . To be honest this has been clear for quite some time so no need to repeat yourself.

As a customer/consumer it is your prerogative to use any product you want and it does not have to be DataEase.

It is doing nobody any good that you constantly keep repeating the same all mantra about Arun Gupta and DQL.

DFD is still out there and anyone that prefer it to any other of our products can use it or any other product they feel works best for them.

The 33% should as stated before be a clue to that a lot is missing from that version that will be part of the final product. 

You can either trust us and think that we have seen the same as you and will fix it, or - if not - be disappointed again that we haven't. 

Anyhow, there is nothing more you can do to force us to see things your way or make the product you see with your inner eye. 

And comments like "being very polite ..a piece of something" is exactly why we don't want to release anything before we are happy that it will not get comments like that.

As we have yet to delete any of our posts on here we have proven that we have a high tolerance on what we accept and that we don't want to edit this forum but as it is a TECHNICAL forum where people can help each other I have to state that your posts are in majority not technical or helpful.

You are more than welcome to keep posting but please limit yourself to posting technical advice and when posting do not post as a comment to another posting things that are not relevant to that posting.


Product: DataEase 9 Developer

Written by: DataEase

28/01/21 14:55:40

Re:Re:Re:How to get DE 9 prerelease to check and idea about DQL ?

[quote]The 33% should in many ways be a clear indicator of how far that version was in its development.... ;-) [/quote]

yup. I've downloaded once more that 33% ... being very polite ..a piece of something ..tried to develop and DQL ...

that was so beautiful relaxation fitness with something even Microsoft did not supposed in their "novell" and so called software tools.

it is very sad very sad. 

DQL from Gupta makes my soul and heart singing cosmic music inside me.

sorry ..but it is the TRUTH


Product: DataEase 9 Developer

Written by: Ihor Zakharchenko

28/01/21 13:25:28

Re:Re:How to get DE 9 prerelease to check and idea about DQL ?

Thank You so much for Your reply, Dear DataEase.

As a pure algebraist from mechanics&maths department of Kyiv national uni I've got my MS diploma via investigating minimized finite automata induced given automata morphism. My Teacher Leo Kaloujnine graduated from Sorbonna and worked there as a lecturer at École normale supérieure. Norbert Wiener met with Kaloujnine in June, 1960 where my Teacher participated in establishing famous Institute of Cybernetics ... I have got my IT experience morethan 40 years ago with my first software application =program in the scope of group and numbers theory made using ALGOL 60 programming language compiled on M220 mainframe the clone of IBM mainframe ...

to be short I need an fresh DE 9 installati9on file to check my idea which will be useful for DataEase team. and I still don't know what is that secret "Legeasy 8" ...

on the pic attached are abacus, my teacher in his uni appartment with father of Cybernetics, June, 22, 1960 ...Kyiv, Ukraine. 


Product: DataEase 9 Developer

Written by: Ihor Zakharchenko

28/01/21 11:16:58

Re:How to get DE 9 prerelease to check and idea about DQL ?

Hi Ihor.
We understand and appreciate your impatience but the DE9 33% was just meant as a showcase to illustrate where we are headed. The 33% should in many ways be a clear indicator of how far that version was in its development.... ;-)

DataEase is a business and as such we need to do thing in the order that we find will give the best outcome.

We have more than 40 years of history to look back at and during those years we have gotten things right and a lot of the time wrong too.

We have also picked up one or two things on what gives good result and what just create noise and distraction.

DE9 is not just a new version of DataEase it is a change in pace, direction and technology unprecedent in DataEase before.

It is not a product developed based on bug fixing or customer feedback on current limitations and problems - that is Legeasy 8 but a version to recruit new and old users to develop new applications in Dataease.

Our experience tell us that if we release a new version of DataEase "to early" no matter if we tell people not to use it in production they will and it creates an enormous support pressure on us when things do not work as it used to or not at all.

So as much as we want to show all of you where we are and how great DE9 is already it is not a ready product and we will not release another beta until we feel its "all there".

DE9 is "to be or not to be" for the future of Dataease so we can't just rush it we need to get it right.


Product: DataEase 9 Developer

Written by: DataEase

28/01/21 10:20:02

How to get DE 9 prerelease to check and idea about DQL ?

G'day dear DataEase Team!

Please make it possible to test the latest (not DE 9 33%) DataEase 9 prerelease for testing. It was stated earlier that some testers are working with the newest downloads of the DE 9 platform. Thank you very much.


Product: DataEase 9 Developer

Written by: Ihor Zakharchenko

13/01/21 16:23:27

[quote] "upcomming Legeasey 8" [/quote]

what is this ? 


Product: Not product specific.

Written by: Ihor Zakharchenko

12/01/21 17:08:44

Re:Sort drop down fields

There is only one way to sort a table based dropdown in DataEase 8.5 or earlier and that is by clustering the table you base the drop down on. This is not a very practicable way of doing it in your case as you based it on a dynamically updated table i.e. employees.

In DE9 and also possibly in the upcomming Legeasey 8 you get Multibox 2.0 where you can sort the list and also make it unique i.e. avoid multiple occurrences of the same choice. This way you can base a dropdown on almost any table as you will get a structured list with unique choices whatever data you base it on.

Ex. You build a dropdown on the Country field on your order form which use a relationship to itself for populating the dropdown. If a country don't exist you simply add it and for the future this choice will be part of the list. 

If you do this in the current version of Multibox you will get them in entered order and you will also get all the matching entries so ex. here in the UK I would get a lot of United Kingdom etries.


Product: Dataease [{8}]FIVE

Written by: DataEase

12/01/21 17:07:21

Sort drop down fields

I am using the tool inventory function of the software. I have drop downs where I can select employees from a list, this drop down in not sorted a-z and does not have all the personal listed. Thank you.


Product: Dataease [{8}]FIVE

Written by: Joshua Rodriguez

07/01/21 15:13:28

Re:Re:Re:Re:Re:Re:Re:Report / Procedure

There is a couple of places you can use code in DataEase (Depending on what version you are using). 

You have DQL, You have BRL(Derivations), You have Actions (Buttons etc) and you have OML.

BRL is on every field object and will give the calculation/result in that field if it is write protected, virtual or if it is not entered manually.

if you have a date field and use the derivation:

Current date

it will fill the date when lost focus if you don't manually fill it with a date.

If you write protected or make it virtual it will fill it immediately.

current is a command/statistical variable in dataease and can be used everywhere you can code.


Product: Dataease [{8}]FIVE

Written by: DataEase

DataEase Mainpage