Easy to Create, Easy to Change - Easy to use!

Support::

and



Parameters


Returns/Result


Examples


Reference

and

Type

Logical Operator

Purpose

The and operator combines two or more sets of selection criteria.

Syntax

SELECTION CRITERIA 1 and SELECTION CRITERIA 2 [and SELECTION CRITERIA 3 . . .]

 

Returns

The values in records that satisfy all of the selection criteria statements.

Usage

The and operator requires that a record meet all the specified selection criteria to be processed. The or operator requires that a record meet any of the specified criteria to be processed. When selection criteria are combined with both the and and or operators in one statement, the criteria must be enclosed in parentheses to clarify the meaning.

Example 1

for MEMBERS with STATE = "NY"

and TOTAL DUE > 500

and LAST NAME between "A*" to "L*" ;

 

This statement tells DataEase to process only those MEMBERS records that contain NY in the STATE field, a value greater than 500 in the TOTAL DUE field, and a LAST NAME value that begins with any letter between A and L (inclusive). Only records that satisfy all three criteria are processed.

Example 2

for MEMBERS with ( STATE = "NY" or STATE = "NJ" )

 and TOTAL DUE > 500 ;

 

This statement tells DataEase to process only those MEMBERS records that contain either NY or NJ in the STATE field and a value greater than 500 in the TOTAL DUE field.

Example 3

for MEMBERS with STATE not = "NY" and STATE not = "NJ" ;

 

This statement tells DataEase to process all the members records except those that contain either NY or NJ in the STATE field.

Again, only records that satisfy all sets of criteria are processed.

See Also


On the forum about and

User deined finctions and DataEase 6.53

I try my aplication -developed in DataEase 6.52- with DataEase 6.53 and some user function don´t work. For example, NumtoText it´s crazy....

Product: LegEasy 6 Windows. Written by Carlos Ruiz 08/10/12 at 00:27:19

Re:User deined finctions and DataEase 6.53

Hi Carloz. I assume you use the demo version of 6.53? This on is limited to 30 records, and since the CDF functions is stored in a normal DataEase table, all function after record 30 will be ingnored and cause this problem. The Demo version is realy j...

Product: LegEasy 6 Windows. Written by DataEase 08/10/12 at 06:25:33

Re:Re:User deined finctions and DataEase 6.53

I delete all User Function except the NumtoText function. A table with one record, but the problem it´s still there....

Product: LegEasy 6 Windows. Written by Carlos Ruiz 10/10/12 at 05:30:12

Re:Re:Re:User deined finctions and DataEase 6.53

Hi again! Sorry for the "lazy" answer. Your problem is related tot he CDF library not being present in the DataEase Program catalogue. CDFs is not normally distributed as part of the DataEase distribution as they are to a big degree third party softwar...

Product: LegEasy 6 Windows. Written by DataEase 10/10/12 at 07:43:53

Problems with Export, Upgrading from 7.2 and DataEase 8 Exec.

• Currently I have a procedure to export data from a table with the following code for detalle-Prestamos ; list records Pretamo_Numero ; Fecha_cobro ; LlaveItems ; Valor_abono . end export to "D:\Detalle.txt" . .form header .items @f[1,1], @f[1,2], @f[1...

Product: DataEase for Windows 7.x. Written by diego fernando ocampo gomez 29/10/12 at 20:14:58

Re:Problems with Export, Upgrading from 7.2 and DataEase 8 Exec.

1. Problem with Export. http://www.dataease.com/dg3_SearchHelp/?PageID=10066 Example 3 for MEMBERS ; list records MEMBERID in order ; CARDNO. ; TOTALDUE . end export to "MEMBDATA.TXT" . .form header .items @f[1,1,5]@f[1,2,20]@f[1,3,7] .end This example...

Product: DataEase for Windows 7.x. Written by DataEase 29/10/12 at 20:23:06

Interface functions and forms

I have long worked with DataEase Windows from version 6.52 to version 7.2.947, and I saw a flaw in the handling of forms and versions that can not be given options for buttons Minimize, Close, for disable power as in almost all the other programming tool...

Product: DataEase for Windows 7.x. Written by wilmer raul contreras riaño 30/10/12 at 14:48:22

Re:Interface functions and forms

Hi again Wilmer. "DataEase for Windows gives and it taketh away..." It is not a development tool, but an RAD framework. You get a lot very quickly if you play along with it, but if you want everything to work exactly the way you want it, you spend a lot...

Product: DataEase for Windows 7.x. Written by DataEase 30/10/12 at 18:12:36

DataEase for DOS and a way forward?

Good Morning We currently have a 7.2 licence, and have lost track of where things are at. I keep revisiting DataEase site with the hope that the promise finally eventuates, and reading the content on this site at the moment, indeed the future looks pro...

Product: LegEasy DOS. Written by David Packenas 15/11/12 at 15:23:27

Re:DataEase for DOS and a way forward?

Hi David. Glad I caught you. LegEasy is basically a "group name" or product line, for products that we make to help customers that are "stuck" in older versions of DataEase. I am an old DFD "dog" myself and for us it is easy to forget/believe that Da...

Product: LegEasy DOS. Written by DataEase 15/11/12 at 15:27:53

Re:DataEase for DOS and a way forward?

I concur. 4.53 still can be very competitive you need things done in a fast way. In my company I am using DE since 1987 (yep Datamaster you recall) We even went up to the Datamaster UK headquarters in the old days to convince there were some calculation...

Product: LegEasy DOS. Written by Stefan Weckx 26/11/12 at 19:13:06

Re:Re:DataEase for DOS and a way forward?

Dear DataEase, I too would very much like to be involved in DataEase LegEasy for Dos and DG3. I have been in previous communication with Ulrik about our site and my 25 years experience of DataEase as a programmer and IT Support person. I've used DataE...

Product: LegEasy DOS. Written by Lee Oatway (Urban Vision) 03/12/12 at 07:57:12

Ffenics alive and kicking!

"?Ffenics have confirmed to us today that their primary website is down but that business continues as normal.&nbsp; For more information please refer to their Facebook page?"Ed Paice<hr...

Product: . Written by DataEase 15/01/13 at 09:53:18

Forgotten Username and Password

[@EOF@]...

Product: DataEase 6.x. Written by Richard Grant 09/05/13 at 19:50:42

Re:Forgotten Username and Password

I last used my Dataease 10 years ago. I have reason to get back into it but have forgotten Username and Password. Is there a way to find what I used then to access my Dataease?? Thanks....

Product: DataEase 6.x. Written by Richard Grant 09/05/13 at 19:52:48

Re:Re:Forgotten Username and Password

Hi!Obviously we can't publish methods of breaking into DataEase databases online, but we obviously have methods to unlock any DataEase app if need be.This is a service that we offer and it cost £49&nbsp;If you want to proceed...

Product: DataEase 6.x. Written by DataEase Support 10/05/13 at 06:34:39

Opening specific form and auto fill

1. How do I open a specific record in a new window from the main form. For-exampl a specific invoice from a list of invoices for a customer? 2. How to open a form in a new window to add a child rec...

Product: Dataease [{8}]FIVE. Written by Ilya 10/07/13 at 11:06:38

Re:Opening specific form and auto fill

ff...

Product: Dataease [{8}]FIVE. Written by Graham Brown 17/07/13 at 09:36:09

Relationships and Referential Integrity

Hi guys, I've got a couple a questions concerning the relationships. I want to try the various options for the referential integrity (cascade, set null, don't update, etc.) and cannot figure out a couple of things....

Product: Dataease [{8}]FIVE. Written by Patrice 21/08/13 at 09:13:21

Re:Relationships and Referential Integrity

1.The reason there is two values is because a relationship goes two ways. So the first field is when the first Table is master and the second one child and the second field is when it is used in reverse. </p...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 21/08/13 at 09:14:20

Tables and Forms in DataEase for Windows - An interesting article

This is an interesting article in which Lawrence Fox discusses separating separate table creation and management from the user interface in DfW. http://computerwiz...

Product: Not product specific.. Written by Kensington 21/10/13 at 16:02:52

Re:Tables and Forms in DataEase for Windows - An interesting article

In DG3 you will be able to have different business logic i.e. TDF files on the same dataset. So the virtualisation will go one step further. You will also be able to build a TDF over several tables i.e. view. You can as...

Product: Not product specific.. Written by DataEase 23/10/13 at 18:36:54

Selection filter on Dataease 7.2 and 8

I'm an old user of DataEase (6.52) and i'm testing the new version (7.2 and 8). There's a difference using the "Select records" button, I mean when the filter doesn't report any records in 6.52 appear a message saying : No records match the selecti...

Product: DataEase for Windows 7.x. Written by Marco Marchesi 07/11/13 at 15:31:00

Re:Selection filter on Dataease 7.2 and 8

Hi Marco.Error messages left right and centre has been reduced to a minium in DE8 (and late DE72). You can however switch them back on for the forms where you want them.Simply go to document properties ans check: Confirm Change...

Product: DataEase for Windows 7.x. Written by DataEase 07/11/13 at 17:20:33

Re:Re:Selection filter on Dataease 7.2 and 8

Great! It works now. But this option is unselected by default. I have a possibility to turn on this option for all the tables? During the DeMigrate from 6.52 version there's a possibility to turn on this option for all the tables? We have a database w...

Product: DataEase for Windows 7.x. Written by Marco Marchesi 08/11/13 at 07:19:37

Save and Close in one action

Good morningIn re-programming the one thing I always need is an Action: Save & Form Close in one functionIs that possible or does it already exist?...

Product: Dataease [{8}]FIVE. Written by Graham 12/11/13 at 12:05:13

Re:Save and Close in one action

It doesn’t exist as one action but it is quite easy to do in two actions. It was a big limitation that one could only have one action on a button when buttons was presented in Express back in 1992. Everyone hoped that it would be amended w...

Product: Dataease [{8}]FIVE. Written by DataEase 12/11/13 at 12:05:37

Re:Re:Save and Close in one action

ThanksSomething to be added!Graham...

Product: Dataease [{8}]FIVE. Written by Graham 12/11/13 at 12:54:32

Re:Re:Re:Save and Close in one action

Hi Graham. Rather the opposite ;-) Actions have never ?sat well? with me. It is one step to far in ?humanizing? the programming part of DataEase. I strongly believe that most things should be easy and understandable, but it...

Product: Dataease [{8}]FIVE. Written by DataEase 12/11/13 at 12:55:09

Export to Merge file Error "This Export Band requires a Table View Name"

I have a procedure that creates an export file to be read in Mail Merge. The data form has about 60 records. There are two problems:-1. If i set it upFor Formlist recordsany form with ( field name = form field name ) fi...

Product: Dataease [{8}]FIVE. Written by 12/12/13 at 14:16:02

Re:Export to Merge file Error "This Export Band requires a Table View Name"

With fear of having misunderstood what you are trying to do.The Export function in DFW DQL has its own special format and limitations.Example 2...

Product: Dataease [{8}]FIVE. Written by DataEase 13/12/13 at 06:49:17

spell date and number in all countries

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by alembagheri tahmas 01/01/14 at 13:45:01

DFD 4.53 ... I know ancient , but still running. We moved to Windows 7 (32 bit) and now all the Imports are not showing, it runs without a problem, but it does not show so we can not make any changes ? Any Ideas ?

[@EOF@]...

Product: LegEasy DOS. Written by charmaine smit 19/05/14 at 12:00:10

Re:DFD 4.53 ... I know ancient , but still running. We moved to Windows 7 (32 bit) and now all the Imports are not showing, it runs without a problem, but it does not show so we can not make any changes ? Any Ideas ?

I use DOSBOX ,&nbsp;http://www.dosbox.com/ and it works fine, both in small and full screen.Remember that DFD does not like long file import names, so you might have to rename them to fit that length....

Product: LegEasy DOS. Written by Kensington 20/05/14 at 16:36:04

ExecDQL and in groups

Hi folks,in the last days I have been testing the use of MemoExecDQL / ExecDQL functions. It seems very powerful and I would like to use it instead the "null printer hack" to speed up and streamline my application. But during my tests I noticed...

Product: Dataease [{8}]FIVE. Written by George Washington 30/05/14 at 14:55:58

Re:ExecDQL and in groups

Is anybody in there?...

Product: Dataease [{8}]FIVE. Written by George Washington 11/06/14 at 06:31:28

Re:ExecDQL and in groups

Sorry for the late reply. We are currently working full out on 8.2 where DQL will be further enhanced.ExecDQL is DQL from "future" DataEase and is not derived from the existing DQL in DFW. Somewhere along the line someone "misunderstood" DQL a...

Product: Dataease [{8}]FIVE. Written by Mr. DataEase 11/06/14 at 11:02:44

De8 and Crystal Reports / Other ?

Has anyone used dataease or any other database for that matter to create raw data for use in another program that create reports?&nbsp; I've heard of Crystal Reports but no idea what it's like or how it works so wondering if anoyone has any experienc...

Product: Dataease [{8}]FIVE. Written by Simon B 12/09/14 at 08:44:57

Forum can't, handle double digit replies

As the forum is based around DG3 it seems right to be under DG3 as this is a visible bug that can't be explained away.When you reach about 12 replies in a thread the replies no longer appear at the end, i.e. continuing the conversation, but app...

Product: DataEase Generation 3. Written by Simon B 25/09/14 at 08:28:56

Re:Forum can't, handle double digit replies

Sometimes this feel like a contest where we are the bad guys and the purpose is to catch us lying.There is a lot of weaknesses in the forum but it is mainly due to it being created in a matter of hours 2 years ago and never improved since.&nbs...

Product: DataEase Generation 3. Written by DataEase 25/09/14 at 15:16:40

Re:Re:Forum can't, handle double digit replies

I questioned if it was sorted according to which section i replied to like you said before even posting this, but it wasn't, hence why it is a bug.&nbsp; Your&nbsp; reply to 'Re:2 2=4' at the END of the thread is '<st...

Product: DataEase Generation 3. Written by Simon B 26/09/14 at 08:02:42

Re:Re:Re:Forum can't, handle double digit replies

Hi Simon.Answers on here will always be a little more generally directed when we do it than the person asking the question wants as we are building a knowledge base as well as answering a question directly.I am sorry that I used your re...

Product: DataEase Generation 3. Written by DataEase 26/09/14 at 09:10:08

Re:Re:Re:Re:Forum can't, handle double digit replies

Me confrontational? never :D .... ok I hold my hands up to that lol, I am.&nbsp; I know I am! and for that I apologise.A lot of it is my own frustration, I'm used to learning things myself, looking things up and working through them.&nbsp; With...

Product: DataEase Generation 3. Written by Simon B 26/09/14 at 10:59:33

Re:Re:Re:Re:Re:Forum can't, handle double digit replies

Good Morning Simon.Don't say that we never listen... ;-)We have now updated the forum so the latest reply always appear at the end of the list. Your observation of the double digit replies was very astute by the way. We "tried" to crea...

Product: DataEase Generation 3. Written by DataEase 30/09/14 at 08:05:58

DataEase 8.2 and JSON

Hi,Is there any way I can send a request to web and get the JSON results and post them back into a field?...

Product: . Written by Jeyarajah Arulrajah 13/10/14 at 13:30:54

Re:DataEase 8.2 and JSON

Hi again Arul.I think we can soon do better than that.We are currently implementing RemoteLookup() which will lookup data via the DataEase Server API. This means that you will be able to read/write data from any location from any DE8.2...

Product: Dataease [{8}]FIVE. Written by DataEase 13/10/14 at 18:40:01

SetState() not working for subform and record1

Hi there,I am running the latest version (8.2.0.1700) of dataease and playing around a little with the subform as a dialogue example. The example works as expected, but I have problems making it work on my application. When I use the SetState()...

Product: Dataease [{8}]FIVE. Written by George Washington 15/01/15 at 10:06:33

Re:SetState() not working for subform and record1

It is annoying that you can't name/rename a lot of objects in the DE GUi model.The most annoying is Record or Record1 as it will become.All Records will end up being called Record1 (before first same and reload of an FRM it is called R...

Product: Dataease [{8}]FIVE. Written by DataEase 15/01/15 at 11:06:55

Re:Re:SetState() not working for subform and record1

Thank you DataEase, you saved me again :) . For the records, it was the case thing. Oh, there is still a problem: if I create a derivation with some wrong cases (e.g. record1) and then change the case only, dataease will not actually change the deriva...

Product: Dataease [{8}]FIVE. Written by George Washington 15/01/15 at 12:00:31

Re:Re:Re:SetState() not working for subform and record1

You are of course right. This is the problem with moving from old to new ;-)One of the deep entrenched principles in DataEase was case-insensitivity to such an extent that it permeates both data and programming. With the introduction of Object...

Product: Dataease [{8}]FIVE. Written by DataEase 15/01/15 at 12:33:57

Exporting data from QBM (mainform and subform)

Today I received a little bang on my head for not able to do this.This is due to exporting data from QBM with main-form and sub-form.Export only works well with main-form data.It does not export sub-form data with the main-form.</...

Product: Dataease [{8}]FIVE. Written by Arul 27/01/15 at 08:22:02

Re:Exporting data from QBM (mainform and subform)

Hi Arul.That bang you should have gotten a long time ago ;-) Direct Export from table (QBM) has only ever exported a flat file i.e. from one level. So if you export the main table you will get all the data in that query (filte...

Product: Dataease [{8}]FIVE. Written by DataEase 27/01/15 at 08:27:57

Re:Re:Exporting data from QBM (mainform and subform)

Yes, I see what you were saying.&nbsp;But, problem is, users going from DFD into DFW expecting the same or similar functions. Unfortunately, I cannot disagree with them. As you well aware, DFD took over the world those days (20 years ago). All...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 30/01/15 at 16:17:12

Re:Re:Re:Exporting data from QBM (mainform and subform)

True, true, true. But I think we have to agree that the future of this product is not people coming over from DFD anymore. That battle was lost 20 years ago. DataEase need to live up to its name, but not as a copy of DFD. There is more features, bette...

Product: Dataease [{8}]FIVE. Written by DataEase 30/01/15 at 16:42:45

Solution:How to align data on the right on a text field with FixedWidth() and StringTo().

Download Sample Thank you for giving us such a brilliant opportunity to show of some of the new and sadly not so well known functions in...

Product: Dataease [{8}]FIVE. Written by DataEase 13/02/15 at 18:13:40

Is MsgBox libray still available in DE8.2 ? If not, how messages should be handled?

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Francesco Toma 14/02/15 at 16:34:38

Re:Is MsgBox libray still available in DE8.2 ? If not, how messages should be handled?

MsbBox library was never an intergral part of DataEase. You always needed to add it to the application after creation.However in DE8 they get pre-loadedi&nbsp;n new applications so it is there but the problem is that it can be doubly defined i...

Product: Dataease [{8}]FIVE. Written by DataEase 15/02/15 at 12:59:05

What is the replacement command for DFD Lookup

I worked/developed applications in DFD in the late '80s - early '90s. I was actually one of your certified partners in the U.S. Now I am looking to upgrade to DE8.5. I have searched the BLOGs and Forums for help with the old LOOKUP command. Seems as t...

Product: Dataease [{8}]FIVE. Written by Lisa 19/02/15 at 14:14:37

Re:What is the replacement command for DFD Lookup

Dear Lisa. Now you take me back. I came back to DataEase myself after a long “holiday” in 2007 and my first “challenge” was exactly the same as yours&hellip; What has happened to Lookup!!!! It was idiotic to cal...

Product: Dataease [{8}]FIVE. Written by DataEase 19/02/15 at 14:15:19

Migrating DFW6.x and to DFW8.2 onwards.

DataEase 8.x is fully compatible Windows 7.x through Windows 8.x and is currently being tested in Windows 10, so far without any problems.You can migrate any DFW 6.x application to DFW 8.2 or later. It will in most cases be completely straight...

Product: Dataease [{8}]FIVE. Written by DataEase 21/02/15 at 10:57:13

Re:Solution:How to align data on the right on a text field with FixedWidth() and StringTo().

Great! It works well. I have another questiom. I have to format a field in this way "000000000.00" in a fixed text field within a length 12 char (padded with zeroes) . The input field is simply a number with 2 decimals. Take in mind that I'm in Italy...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 27/02/15 at 09:53:56

StringReplace(), CHR(), LastC() and ConCat() used to reformat number to export number

Download Sample This is quite straightforward but as it again showcase some of our new functions we'll happy to showcase it. We simply added th...

Product: Dataease [{8}]FIVE. Written by DataEase 28/02/15 at 15:00:40

Different font size for reports and DQLs on different workstations.

when i design dql's for reports using different computers. my fonts show the view body /view header /view footer text in different font sizes. running the same dql on different computers for output also displays differently. one win7 computer uses sma...

Product: Dataease [{8}]FIVE. Written by George Z 20/03/15 at 06:57:34

Application that Showcase how you can write-protect and search with paste in a Form.

Download Sample! As you all point out, this worked in DFW up to 7.2 but not in 8.x. Most likely it worked in 8.0 but somewhere along the way this was "corrected".<br...

Product: Dataease [{8}]FIVE. Written by DataEase 20/03/15 at 09:10:50

Re:Application that Showcase how you can write-protect and search with paste in a Form.

It's a text field, it's searching for a piece of text in a text field.&nbsp; I can type my search in a text field after choosing query start from menu/button/shortcut, why has the ability to paste a piece of text in a text field been removed??&nbsp; H...

Product: Dataease [{8}]FIVE. Written by Simon B 20/03/15 at 10:36:17

Re:Re:Application that Showcase how you can write-protect and search with paste in a Form.

"We did a lot with copy/pasting in Memo fields so it might be related to that. It is of the list of fixes, but it is a long list...

Product: Dataease [{8}]FIVE. Written by DataEase 20/03/15 at 11:01:22

Re:Re:Re:Application that Showcase how you can write-protect and search with paste in a Form.

It doesn't works even on your sample database if I set prevent-entry to ON using degroup version 8.2.0.1696 or higher. If I use degroup version 8.1.0.1464 it works anyway. ...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 10/04/15 at 08:58:59

Re:Re:Re:Re:Application that Showcase how you can write-protect and search with paste in a Form.

The sample showcase how you can do it without setting Prevent-entry on. You do the write protect manually via SetState().If you disable the Form with SetState() it will not be disabled when in Table View or when Being In Search View....

Product: Dataease [{8}]FIVE. Written by DataEase 10/04/15 at 11:12:36

Objects name in OML and in design form

Today I stumbled in one of the most nasty bug I have ever found. I have a form with 20 fields Named M01, M02... etc. till M20. There are also other fields, but those are ones with issues. When I created them I designed the first one and - as all of th...

Product: Dataease [{8}]FIVE. Written by George Washington 16/04/15 at 07:11:08

Re:Objects name in OML and in design form

Hi George, I copy paste fields a lot and I've never seen this as a bug tbh.You always had to change the object name at the same time as field name after copying.&nbsp; Just edit the field, change field name, the click the object name radio butt...

Product: Dataease [{8}]FIVE. Written by Simon B 16/04/15 at 11:23:57

Re:Re:Objects name in OML and in design form

Is not a bug as long as you are aware of it, I spent more than an hour to figure it out....

Product: Dataease [{8}]FIVE. Written by George Washington 16/04/15 at 12:24:41

Re:Objects name in OML and in design form

I guess this is covered more or less, but will give some background.When I first came across this "idiosyncrasy" i thought it was hilarious/stupid that there was two names for a field.To top that, when you copied a field the ex. named...

Product: Dataease [{8}]FIVE. Written by DataEase 16/04/15 at 13:06:15

QBM - How to create your own crashing database with 1 table and 2 fields.

Trying to create a test for a dataease crash and can't because dataease crashes during creation of a basic test database! lol.&nbsp; Easily duplicated and I did it again from scratch in an empty folder in under 5 minutes, so here's how to do it.<p...

Product: Dataease [{8}]FIVE. Written by Simon B 17/04/15 at 13:01:24

DE8.2 and DE8.2 group are not equal ?

Hallo Dataease forum,i have found out that if i develop an Form with a memo HTML field in the DE8.2 developer version (latest)and than i start the same form in DE8.2 group (latest) that the memo HTML field has no funktion!I am not...

Product: Dataease [{8}]FIVE. Written by Markus 11/05/15 at 18:02:45

Re:DE8.2 and DE8.2 group are not equal ?

There is a problem with the HTML field in the later versions of 8.2 This is fixed in 8.5.The fix in 8.2 is simply to copy the entire HTML catalogue from 8.2 Full to 8.2 Group.You find the HTML catalogue on the root of DataEase 8.2 and...

Product: Dataease [{8}]FIVE. Written by DataEase 12/05/15 at 11:29:02

Re:Re:DE8.2 and DE8.2 group are not equal ?

Hallo Dataease Forum,thank you for this Information. I have made the copy you described from DE 8.2 (8.2.0.1700) to DE 8.2 Group.But it seems that the same problem keeps there! If i open the form with the HTML Field in it i can see only...

Product: Dataease [{8}]FIVE. Written by Markus 15/05/15 at 11:12:57

DataEase 8 and barcodes

is there any possibility to get information to system through another port as keyboard port.e.g. we would like to get information through a barcode scanner into Dataease software. Is it possible?...

Product: Dataease [{8}]FIVE. Written by Sven 29/05/15 at 12:56:28

Re:DataEase 8 and barcodes

Most Barcode readers use the Keyboard buffer to get the data into the application. We have ?"millions"? of application that use a simple USB Barcode reader that basically just read the result into the active field via the keyboard buffer.<...

Product: Dataease [{8}]FIVE. Written by DataEase 29/05/15 at 12:57:08

Re:Re:Re:DE8.2 and DE8.2 group are not equal ?

Sorry for the late feedback.&nbsp;This has been put on the fix list of the release team and as they are very busy it has been taking some time.They have now finally had time to have a look and it is very strange, but your headline is c...

Product: Dataease [{8}]FIVE. Written by DataEase 02/06/15 at 13:13:33

Re:Re:Re:Re:DE8.2 and DE8.2 group are not equal ?

New 8.5 Group released today.http://www.dataease.com/static/files/DataEaseGroup...This is not the final version of 8.5 but we have decided to release a...

Product: Dataease [{8}]FIVE. Written by DataEase 03/06/15 at 13:34:02

Custom CDF and strings

Hi there,I read the blog entry on how to create custom cdf and I am really excited about that. It has been long time since I desired to add some function and cannot do that was kind of frustrating. Anyway, I followed the example and everything...

Product: Dataease [{8}]FIVE. Written by George Washington 09/06/15 at 14:57:16

Re:Custom CDF and strings

Hi George, and thanks for the interest in extending DfW your self using a custom CDF.The most common reason for DfW to crash when returning a string from a CDF is simply that the memory used by the string it self is&nbsp;released before DfW can...

Product: Dataease [{8}]FIVE. Written by DG3 Development 10/06/15 at 10:33:25

Re:Re:Custom CDF and strings

Pretty much on the same subject about creating CDF.Windows o/s alone comes with 100s of functions. For us to use the Windows API, we need an add-on into DataEase. As soon as we can use that Add-on. We can open up Windows API and use 1000s of fu...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 10/06/15 at 13:26:23

Re:Re:Re:Custom CDF and strings

Arul... Simplistic solutions aren't always the simplest solutions. ;-)The CDF interface is very much an interface to the Windows API and everything else.There is no way you can magically create a way to use the WIndows API that is any s...

Product: Dataease [{8}]FIVE. Written by DataEase 11/06/15 at 12:32:02

Re:Re:Re:Custom CDF and strings

When you refer to the previous Developers attempting to access the Windows API you are thinking of using ShellExecute to call some Shell functions in Windows. This is not strictly the same thing.<a href="https://msdn.microsoft.com/en-us/librar...

Product: Dataease [{8}]FIVE. Written by DataEase 11/06/15 at 12:45:27

Re:Re:Re:Re:Custom CDF and strings

No. I am talking about different thing here.Actually I managed to dig into old documents and found&nbsp;this.In the following script, addressof is the new function introduced by the DE developer in the past.Not sure whi...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 11/06/15 at 13:14:36

Re:Re:Custom CDF and strings

Thank you G3 development for the clarification. I am still missing something on CDF development, cause a lot of very simple routines give GPF in an apparently random way. I can't help to read more about that topic. I know the development team is reall...

Product: Dataease [{8}]FIVE. Written by George Washington 11/06/15 at 13:16:44

Re:Re:Re:Re:Re:Custom CDF and strings

Arul. I think you have just proven my point here.With DataEase you can get the default printer name and also set a default printer automatically as following:Step 1:Create foll...

Product: Dataease [{8}]FIVE. Written by DataEase 11/06/15 at 13:43:04

Re:Re:Re:Re:Re:Re:Custom CDF and strings

I see what you were saying.But, some clients already feeling DataEase 8.x developer is way advance than previous versions.I am ok with this :-)...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 12/06/15 at 18:57:43

Re:Re:Re:Custom CDF and strings

Hi, to call with parmeters as input is a bit more complicated than the first example in CDF part1. Here is part 2 that tells more of the story of creating CD...

Product: Dataease [{8}]FIVE. Written by DG3 Development 14/06/15 at 10:21:47

Escape in DataEase 8 NEW FUNCTIONALITY! Chr() and StringEscape()

Dear Gorge.Your contributions to the "enlightenment" of the DataEase user base in invaluable. We need these pointers to get the message out there about challenges and solutions.First on a happy note...he,he.Several of our devel...

Product: Dataease [{8}]FIVE. Written by DataEase 22/06/15 at 09:09:47

Re:Escape in DataEase 8 NEW FUNCTIONALITY! Chr() and StringEscape()

Oh, thanks, as a long time fora user (and formerly usenet user) I really think sharing information is the basis in the IT. I hope not bothering too much with my constant questions. Anyway, now everything works like a charm....

Product: Dataease [{8}]FIVE. Written by George Washington 22/06/15 at 11:53:44

Re:Re:Escape in DataEase 8 NEW FUNCTIONALITY! Chr() and StringEscape()

No BOTHER at all! We can only reply if people as the question.The more things get put out there the easier it if for everyone to pick it out and use it.There is so much new stuff in DE8.x so we need to keep on "harping" to get it all o...

Product: Dataease [{8}]FIVE. Written by DataEase 22/06/15 at 12:16:35

Grouping and Header

One of the time consuming issue I always come up with during the conversion from DFD to DFW.Displaying a field value from group on header. Either we have to put the field in items and use summary variables.Or with the new D8 technique, usin...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 22/06/15 at 18:15:54

Re:Grouping and Header

Some times I think you do this just to wind me up Arul ;-)QBM and DQL Reports as introduced in DFW 5.x has never worked. QBM was an over idealised idea back in the early 90ies and the "crazy" idea that "someone" in Sapphire had of using it as...

Product: Dataease [{8}]FIVE. Written by DataEase 22/06/15 at 18:53:38

Re:Re:Grouping and Header

I completely agree with you on what you were saying.BUT, DataEase is now your baby. So, it does not make any sense to blame previous owners...etc.We need to at the minimum find a workaround to use D8.Anyways, I am attaching a databas...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 22/06/15 at 21:53:07

Re:Re:Re:Grouping and Header

Explaining not blaming Arul ;-)I don't think I say anything that not everyone having used DataEase for WIndows have thought and wondered about.QBM and DQL is left in DE8 for backwards compatibility.&nbsp;You are hitting the nail...

Product: Dataease [{8}]FIVE. Written by DataEase 23/06/15 at 07:59:33

Re:Re:Re:Re:Custom CDF and strings

Hi there,thank you for this tutorial, very useful and informative. I went through it and it seems pretty clear. I have just one question regarding the memory space taken by the input variables. In the CDF form there are five types defined in th...

Product: Dataease [{8}]FIVE. Written by George Washington 23/06/15 at 07:45:14

Summary Variables Dialog to insert fields in Header and Footer (Forgotten art)

Download Test.PDF which show the result! Just to showcase how many times this has been "addressed", there is 3 different ways to insert a...

Product: Dataease [{8}]FIVE. Written by DataEase 23/06/15 at 08:54:36

Fields order on DBE and exporting with ExecDQL

Export via DQL would definitely solve this problem and I might be intentionally obtuse when I say I don't understand what you mean when you say that this function is particularly slow... ;-)You mean of course the horrible export to file stuff t...

Product: Dataease [{8}]FIVE. Written by DataEase 23/06/15 at 21:13:15

On the blog about and

New Function in 8 - UniqueID() - Returns a "Random" Unique ID as Key for a Record (Ver 8.0.0.1139)

One of the most popular and frustrating functions or should we rather say functionalities in DataEase is "Sequence from". Basically this is a "guaranteed" sequence number, and it is great when you need records to be in sequence and have a unique number....

Product: Dataease [{8}]FIVE. Written by DataEase 01/10/12 at 07:42:05

New Function in 8 - GetCurrent() - Returns some long awaited values like AppPath, DePath and MyDoc (Ver. 8.0.0.1137)

DataEae has been a little "wobbly" on referencing external stuff like Images etc.There is an Imagepath in Application Preferences, but it has been rendered "defunct" so many times over the years, and nobody is really sure how it works anyway, s...

Product: Dataease [{8}]FIVE. Written by DataEase 26/09/12 at 07:53:14

Re:New Function in 8 - UniqueID() - Returns a "Random" Unique ID as Key for a Record (Ver 8.0.0.1139)

Am I right in stating that this function replaces the Set/Get Uneek CDF? And is it right to assume that this unique id can be used to retreive records etc? thanks...

Product: Dataease [{8}]FIVE. Written by Josef Vella 11/10/12 at 12:39:01

Re:Re:New Function in 8 - UniqueID() - Returns a "Random" Unique ID as Key for a Record (Ver 8.0.0.1139)

Hi! This is simply a function that genearte a "guaranteed" unique ID that one can use as one please, but the short answer to the question is... Yes! In PRISM 9, and ID like this will be an integral part of the database design, but till then you will ne...

Product: Dataease [{8}]FIVE. Written by DataEase 11/10/12 at 12:49:33

New Function in 8 - SetColor() - Change the Fill, Border and Font of Fields/Buttons (Ver. 8.0.0.1158)

This is the last function in the triumvirate, SetFocus()- SetState() and SetColor(). With this last function you will now be able to set the focus/cursor on a Field/Button, hide/show, enable/disable and finally change the appearance from a derivation or...

Product: Dataease [{8}]FIVE. Written by DataEase 19/11/12 at 19:44:55

New Functionaliy in 8 - Changed and Updated RT Editor - (Ver. 8.0.0.1172)

One of the things we really wanted to add to 8 was a RichText editor for editing documents, web content or simply add some "flavour" to your applications. Up to 8, DataEase data have only been able to be presented in one font, colour, size etc. You cou...

Product: Dataease [{8}]FIVE. Written by DataEase 01/12/12 at 11:18:21

New Function(s) in 8 - SetVar() and GetVar(), set and read named global variables (Ver 8.0.0.1176)

These two functions have been partly implemented for a while, but due to structural changes in PRISM we had to disable them in release. These changes have now been made and they are free to use.It is more than 30 years since DataEase 1.0 was re...

Product: Dataease [{8}]FIVE. Written by DataEase 04/12/12 at 10:06:48

New Function in 8 - StringFrom() - Search a string from the tail and return it. (Ver 8.0.0.1196)

This useful little function is part of a full set including StringTo() and StringBetween().StringFrom() search the input string from the tail end inwards looking for the search string. When it finds it, it returns the tail of the string up to...

Product: Dataease [{8}]FIVE. Written by DataEase 15/01/13 at 15:07:45

DataEase 8 Solution/Example - Browse for image and set image field for preview.

We will soon launch our solution database, but nothing wrong with a "preview" of what it is all about.A customer had problems with attaching images to a customer profile in 8 so we just made this solution to help the situation.It is ra...

Product: Dataease [{8}]FIVE. Written by DataEase 08/02/13 at 11:15:59

DataEase 8 Default Template - Document Editor with Mail Merging and Formatted Printing (Ver. 8.0.0.1230)

The Default Template in DataEase 8 Pre-Release has been updated with a small example that show how you can build documents with Memo functions, Merge in field information, edit the document in WYSIWYG editor and finally print document properly formatt...

Product: Dataease [{8}]FIVE. Written by DataEase 22/02/13 at 10:03:19

Mail send action now handles attachments

The mailsend action module has got a new method named sendmailwithattachments. This method do the same as mailsend, but can also take a list of files as a parameter. Make sure you have DG3 v.0.12.978 or newer.This is how the mailsend act...

Product: DataEase Generation 3. Written by DG3 Development 17/04/13 at 12:40:47

New Small Sample - Self populating Dropdowns, Dynamic labels and messages (Ver 8.0.0.1298)

Download SampleThis small Sample is just a study as part of our new Sample App that will be a fully working CRM/Order/Invoicing system.8 is...

Product: Dataease [{8}]FIVE. Written by DataEase 24/05/13 at 17:28:25

Functionalty Fix in DataEase 8 - Buttons updated and fixeds so resizing and label fit (Ver. 8.0.0.1308)

Strangely the buttons in DataEase for WIndows have lived their own lives. You work hard to get the label in the right place and then the next time you open the app, they have moved up or down, only half the label is visible etc...Whatever you...

Product: Dataease [{8}]FIVE. Written by DataEase 18/06/13 at 22:43:32

New Sample - Data Export in DQL, ExecDQL and with DataExport() explained!

Download SampleIt is no secret that data export which used to be so easy and natural in DFD has been a nightmare in DFW. Especially the DQL export.If you do a...

Product: Dataease [{8}]FIVE. Written by DataEase 25/07/13 at 18:24:45

DataEase 8 and Samples

We sense from a lot of users that they have become used to a static DataEase. When it is released, that's it! If it's missing then we wont get it.You might wonder why we release DE8 Classic in the middle of the summer, and why there is so litt...

Product: Dataease [{8}]FIVE. Written by DataEase 31/07/13 at 09:21:35

Migrating an app from DFD to DE8 - Do or don't and how...

Our goal with DataEase is not to constantly focus on migrating old apps or pestering old customers with new upgrades. Our goal is to make it easy to develop in DataEase again so that new applications is quick and simple to make.One of the reas...

Product: Dataease [{8}]FIVE. Written by DataEase 01/08/13 at 09:19:27

Important Fix in 8 - Table Already exist and mismatch between form and table (Ver. 8.0.0.1364)

DataEase 8 development has branched out. Up till now we have solely focused on adding new functionality to 8 and bug fixing has only been done when related to new functionality or old functionality impacted/used/involved in new functiona...

Product: Dataease [{8}]FIVE. Written by DataEase 20/08/13 at 16:33:08

Update of Feature in 8 - New, richer and much improved RT Editor (HTMLEdit) (Ver. 8.0.0.1371)

We are sure that if you had asked the old team - and we are sure some of you did - you would have gotten a long explanation about data consistancy, structure, design which would end up with it being better the way it is (was). The bas...

Product: Dataease [{8}]FIVE. Written by DataEase 04/09/13 at 09:08:45

New Sample - DQL with no output and the superiority of ExecDQL over traditonal DQL... You won't believe it!

Download Sample If you are just looking for a way to "fool" DataEase into not generating any visual output there is several ways, just remember that all...

Product: Dataease [{8}]FIVE. Written by DataEase 16/09/13 at 13:31:43

DataEase 8 - Current Work. Expanding Text field to 4080 characters.

We are currently implementing things to improve both current functionality and backwards compatibility. LongText One of the biggest problems for customers migrating from pre 7.x DataEase to 7/8 is the re-assignme...

Product: Dataease [{8}]FIVE. Written by DataEase 17/09/13 at 07:42:10

DataEase 8 Tips and Tricks - CTRL-F10/Dynamic Lookup/Multibox (Ver. 8.0.0.1463)

One of the most used and popular functionalities in DFD was CTRL-F10 or dynamic lookup. It was THE way to lookup data and bring them back to your form.In DFW this functionality has not been equally popular so why is that?A big problem fo...

Product: Dataease [{8}]FIVE. Written by DataEase 31/01/14 at 11:54:27

Extension of Derivations on Fields and Buttons in (ver 8.1.0.1523)

The derivations on fields and buttons (Execute Function/Derivation) has up to now been limited to 255 characters.This has mostly been enough, but with the emergence of the ExecDQL class and all the new functions in SetClass(), GetClass(), Memo...

Product: Dataease [{8}]FIVE. Written by DataEase 01/04/14 at 18:05:05

DataEase 8.2 - QBM and DQL preview. Manual lay-outing now partially fixed (Ver. 8.2.0.1558)

Download DataEaseTimed-8.2.0.1558 NB! This preview will install parallel to your production version of...

Product: Dataease [{8}]FIVE. Written by DataEase 23/06/14 at 20:18:23

DataEase 8.2 - QBM and DQL Preview - QBM Layout ordering changed. DQL full free (Ver. 8.2.0.1571)

DataEaseTimed-8.2.0.1571.exeThis is the latest compilation of 8.2 Beta. It is still not finished, but the DQL and QBM is getting closer to a w...

Product: Dataease [{8}]FIVE. Written by DataEase 28/07/14 at 10:03:37

DataEase 8.2 Developer - ALWAYS able to switch to Design Mode and view Catalogue

Somewhere along the line from DataEase Express to DFW the ability to switch to Design Mode when you started an application with a Start-Up document was introduced.&nbsp;It is not hard to realise why it was done, but like so many other "hard co...

Product: Dataease [{8}]FIVE. Written by DataEase 20/08/14 at 10:07:32

DataEase 8.2 - Expanded Functionality SetState() - ClickObject added (Ver. 8.2.0.1604)

Download Sample SetState() has been one of the most useful additions to DataEase 8 and we have expanded the scope of it yet again. It already show and hide obje...

Product: Dataease [{8}]FIVE. Written by DataEase 20/08/14 at 16:59:56

DataEase 8.2 - Movement Project initiated, Height and Width added (Ver. 8.2.0.1619)

Download MoveObject Sample You can say that DataEase 8 is the 1968 or "flower power " version of DataEase. For so many years, DataEase for Windows has been confin...

Product: Dataease [{8}]FIVE. Written by DataEase 28/08/14 at 07:56:28

How to: Create your own SpeelWeekday() and yes/no for language support

Download Sample The main problem with using an English version of DataEase is things like Spell functions and yes/no. These are functions that a lot of users have grown fo...

Product: Dataease [{8}]FIVE. Written by DataEase 30/09/14 at 22:25:27

DataEase 8.2 - Fix so Web field and HTML editor will work correctly on Tab/Scroll/Hide/Show (Ver. 8.2.0.1677)

Web fields including HTML editor has not worked the same way as other field controls up till now. They have not scrolled properly, they have not worked on Tabs and you have not be able to hide/show them the same way as with other fields (SetState()).<...

Product: Dataease [{8}]FIVE. Written by DataEase 11/11/14 at 22:39:24

DataEase 7.x and 8.x - Problems and Workaround for Installing Form with Table and Data.

We have just tested this and it works "fine".We suspect that the problem is not really related to DE 8.2.0.1679 but a general problem with Installing Forms with Tables (TDF) and Data (DBM).When you select a Document during install it w...

Product: Dataease [{8}]FIVE. Written by DataEase 14/11/14 at 12:40:33

DataEase 8.2 - New Sample showcasing Email (full) and PDF, MoveObject etc... (Ver. 8.2.0.1686)

Download Email and PDF sample This is not an article but a quick explanation of the sample application attached so you can "steal" the features we use.&nbsp;it is...

Product: Dataease [{8}]FIVE. Written by DataEase 14/11/14 at 18:16:20

DataEase 8.2 - GetCurrent("Xpos" and "Ypos") for objects added (Ver. 8.2.1.1691)

Downlaod Updated PickLists App AIf you are familiar with our latest "play thing" MoveObject() you would also be aware that there has been some shortcomings. As...

Product: Dataease [{8}]FIVE. Written by DataEase 19/11/14 at 16:15:24

HTMLEditor and how to use

The HTMLEditor is pre-configured and you can't change the configuration from inside DataEase. We are planning to add a "minimal" version too at a later stage. However the toolbar is quite "heavy" so we have changed it in the next release t...

Product: Dataease [{8}]FIVE. Written by DataEase 23/11/14 at 10:57:09

Tips! OML Event String and Event Returns

Event StringsThe most useful part of OML is the Events. All other aspects of OML has in effect been replaced by functions in DE8, but events is the dimension you cannot replace as the essence of it is the triggering.T...

Product: Dataease [{8}]FIVE. Written by DataEase 02/12/14 at 11:59:37

DataEase 8.3 BETA1 - Additions and Fixes (Ver. 8.3.0.1730)

Download DataEase 8.3 Beta 1 - PreviewWhen we do big structural changes to the product, we prefer to run it through a short Beta program...

Product: Dataease [{8}]FIVE. Written by DataEase 10/01/15 at 13:34:36

Developer Tips! FixedWidth() and StringTo() in practice ...

Download Sample Thank you for giving us such a brilliant opportunity to show of some of the new and sadly not so well known functions in...

Product: Dataease [{8}]FIVE. Written by DataEase 13/02/15 at 18:56:43

DataEase 8.5 - What is new and function lists

We have currently done a revision on the function description on new functions in DataEase 8.0 to 8.5 as well as the Blog entries made throughout the development. We have also sorted them in order so you can follow the progress through the product.<br...

Product: Dataease [{8}]FIVE. Written by DataEase 23/02/15 at 13:18:45

DataEase 8.5 BETAII - Focus on Migration from DFW 5.x and 6.x (Ver. 8.5.0.1757)

Just a quick update on 8.5 Beta II In this update we have re-visited Migration from DFW 5.x and 6.x to DE8.5. As it turns out this is not straight forward (big wonder), especially if you mix in Language, date-format, decimal se...

Product: Dataease [{8}]FIVE. Written by DataEase 12/03/15 at 16:32:54

Application that Showcase how you can write-protect and search with paste in a Form.

Download Sample! In the attached sample we use SetState(), Custom Menu and Custom Toolbar to "force" the user to use our functionality correctly. Se...

Product: Dataease [{8}]FIVE. Written by DataEase 20/03/15 at 10:47:38

Making icons and picture buttons with Fonts (WingDings, WebDings)

One of the best ways to make graphical buttons etc in DataEase 8 is by using Graphical fonts on buttons. You simply choose WingDings as font on the button and then you select the correct image from the list below.Have a go!We will make...

Product: Dataease [{8}]FIVE. Written by DataEase 31/05/15 at 16:01:36

DataEase 8.5 and programming vs. DataEasy... (How to use programming to bend the imagefield to your bidding!)

Download Sample!<stron...

Product: Dataease [{8}]FIVE. Written by DataEase 22/06/15 at 11:24:29

PDFplay in DE8.5 using MemoExecDQL and HTML.

Download Sample! PS! You will need the latest version of DE8.5 BETA to run this sample, you will fin...

Product: Dataease [{8}]FIVE. Written by DataEase 07/07/15 at 11:49:54

Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

WOW!This is very good. My next project will be in 8.5......no question about it.BTW: since you are building "SR-71 Blackbird"....I thought no harm in asking :-)...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 07/07/15 at 14:36:56

Re:Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

He,he!&nbsp;Never harm in asking. It is your best "skill" that you are never afraid of asking the question. If one don't ask one won't get an answer....

Product: Dataease [{8}]FIVE. Written by DataEase 07/07/15 at 15:41:00

+Wait(0.1)+ What is this and why is it so important in DataEase 8?

DataEase for Windows use POST to launch functions. For those of you that doesn't know the difference between POST and SEND in Windows I will offer a simple explanation.POST means fire and forget and leave it all to windows.SEND means - "He...

Product: Dataease [{8}]FIVE. Written by DataEase 13/07/15 at 15:58:24

Sample! SimplePDF, learn how to use ExecDQL to create PDF quick and easy!

Download Sample! This sample might be a little out of "context" as we have had this feature in DE85 for "many" weeks alre...

Product: Dataease [{8}]FIVE. Written by DataEase 07/08/15 at 09:16:50

For our new users: How to calculate time and some other stuff...

Download Sample! Time computation in DataEase is very straightforward as you have a tim...

Product: Dataease [{8}]FIVE. Written by DataEase 18/09/15 at 07:08:09

DataEase 8.5 BETA! Finally. System/Install Document with Table and Data is fixed (Ver. 8.5.0.1918)

One of the most useful maintenance features in DFD was install Form/Report/Table etc.And like so many other things from DFD, it never worked the same in DFW if at all.You could get it...

Product: Dataease [{8}]FIVE. Written by DataEase 16/10/15 at 16:27:45

Re:DataEase 8.5 BETA! Finally. System/Install Document with Table and Data is fixed (Ver. 8.5.0.1918)

Yes!!!Finally!!One of the useful and important feature. I haven't tested this. But, I take your word for it.I think DataEase 8.x is getting into 21st century. But, slowly :-)...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 16/10/15 at 17:55:44

Re:Re:DataEase 8.5 BETA! Finally. System/Install Document with Table and Data is fixed (Ver. 8.5.0.1918)

To be honest, this is definitely a 20th Century feature.I can guarantee you that DE8 is solidly in 21st Century but possibly it is not that "visible" yet....

Product: Dataease [{8}]FIVE. Written by DataEase 18/10/15 at 12:12:16

Re:Re:Re:DataEase 8.5 BETA! Finally. System/Install Document with Table and Data is fixed (Ver. 8.5.0.1918)

One thing I can guarantee, you will attract more customers. Is to add interactive DQL like DFDWhen someone types or selects FOR.....then DataEase automatically gives all the tables to select.....etc....

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 19/10/15 at 03:52:09

DataEase 8.5 and the BETA Program.

We had a lot of questions about the long beta program for DE8.5, last on the forum so it might be time with a pointer about what is going on, what we plan and why we do it like this.As you know...

Product: Dataease [{8}]FIVE. Written by DataEase 28/10/15 at 07:54:37

DataEase 8.5 - AutoRefresh Form and other nifty tricks (8.5.0.1918)

Download Sample! We guess this is a good opportunity to show an alternative method to OpenRelated() with better developer control, and also how to m...

Product: Dataease [{8}]FIVE. Written by DataEase 26/11/15 at 11:15:46

DataEas 8.5 - Automatic Migration from DFW 5.x (DFD 5.x) 6.x, 7.x and 8.0-8.2 to 8.5 (Ver. 8.5.0.2002)

There was a lot of "Crazy" decisions made in the Move from 6.x to 7.x that the user and ultimately DataEase had to pay the price for.As you might be aware of it was a completely different d...

Product: Dataease [{8}]FIVE. Written by DataEase 01/12/15 at 16:56:37

DataEase 8.5 - Better management of User Apps and control Startup image. (Ver. 8.5.0.2006)

The first "finished" product of the DE8.5 line will be released later this month, but it is just the first in line.Over the last couple of months, we have split the DataEase Product into different lines.DataEase 8.5 Developer will now si...

Product: Dataease [{8}]FIVE. Written by DataEase 01/12/15 at 18:05:10

DataEase 8.5 - Record1 Object name fix and Renaming Enabled (Ver. 8.5.0.2028)

As we are getting closer to DE85 Developer release, we are obviously also getting closer to "full circle" when it comes to functionalities.Something that started with the simplest of SetColor()...

Product: Dataease [{8}]FIVE. Written by DataEase 01/12/15 at 18:25:29

Pre-Release of DataEase 8.5 Developer and DataEase 8.5 Player.

We are happy to announce that DataEase 8.5 Production release is getting closer and closer ant that we aim to have the official versions out as the official release of DataEase 8 next week.The first full versions of the products are available...

Product: Dataease [{8}]FIVE. Written by DataEase 14/01/16 at 17:15:21

Re:Pre-Release of DataEase 8.5 Developer and DataEase 8.5 Player. Thank You! What about trial licenses for both ?

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Ihor Zakharchenko 18/01/16 at 09:32:11

Re:Re:Pre-Release of DataEase 8.5 Developer and DataEase 8.5 Player. Thank You! What about trial licenses for both ?

You can use any valid DE8 license both Trial and Full.We don't issue trial licenses at the moment....

Product: Dataease [{8}]FIVE. Written by DataEase 18/01/16 at 13:59:56

Re:Re:Re:Pre-Release of DataEase 8.5 Developer and DataEase 8.5 Player. Thank You! What about trial licenses for both ?

Will wait for trial license then. It is normal&nbsp; for Ukraine reality now ;)...

Product: Dataease [{8}]FIVE. Written by Ihor Zakharchenko 18/01/16 at 15:56:44

New Feature in DE85 Player: FULL SCREEN and KIOSK Mode.

You might have realised that something is going on in the "kingdom" of DataEase and we can reveal that it is quite a lot. In the past the Exec, Group, Runtime...

Product: Dataease [{8}]FIVE. Written by DataEase 22/01/16 at 13:38:38

How to highlight active record in a subform by using GetCurrent("RowNumber"), SetStyle(with * and #) and GotFocus/Mousdown.

Download Sample We got a very good question o...

Product: Dataease [{8}]FIVE. Written by DataEase 28/01/16 at 11:26:05

[{8}]five Release and Release program.

In many ways DE8.5 could have been released over a year ago as there was more than enough new features this time last year to defend such a decision, but we decided not to. Si...

Product: Dataease [{8}]FIVE. Written by DataEase 29/01/16 at 16:12:15

Available Products, De-supported Products and available for licensing

We frequently get enquires about the availability of older versions of DataEase as well as the status of bug fixing/support for these products. Above you see a t...

Product: Dataease [{8}]FIVE. Written by DataEase 01/03/16 at 10:59:49

New Release of 8.5 - Toolbars etc. now properly sorted and virtual Forms (Ver. 8.5.0.2222)

If you have been using the later releases of DataEase 8.5 and experimented with switching on/off toolbars/tabbars etc you might have experiences some peculiar behaviour....</p...

Product: Dataease [{8}]FIVE. Written by DataEase 11/03/16 at 12:14:27

Re:DataEase 8.5 - AutoRefresh Form and other nifty tricks (8.5.0.1918)

Sample updated to 8.5.1 version. Will not work in previous versions of DataEase 8.x...

Product: Dataease [{8}]FIVE. Written by DataEase 13/04/16 at 16:58:20

How to adjust DataEase 8.5 to use the Non-English characters with the HtmlEdit and text fields

-&nbsp;First, make sure that&nbsp;your system use the correct&nbsp;"System Local" language of the Non-English&nbsp;characters you use in DataEase: The system locale determines the default character set (letters, symbols, and numbers) an...

Product: Dataease [{8}]FIVE. Written by Fatma Adel 18/04/16 at 06:57:29

LegEasy4DOS: How to map drives in session for input/output and use them to take a backup.

In this video we show you how you set up a session and map the default input/output drives. LegEasy4DOS run in i...

Product: LegEasy DOS. Written by DataEase 15/06/16 at 14:34:22

LegEasy4DOS: How to create a new application and restore a backup

Here we show you how you can create a NEW application (DFD Application) in LegEasy4DOS and then restore a backup over it....

Product: LegEasy DOS. Written by DataEase 15/06/16 at 14:57:58

Global Unique Sequence Number via Remote() and DataEase Server. (Min 8.5.0.2222)

Download Sample! We have just for fun created a small sample that showcase how one can have a global...

Product: Dataease [{8}]FIVE. Written by DataEase 07/07/16 at 10:54:51

DataEase 8.5.0.2275 - Big DEOS Update Added DEOS function @zip, @unzip, @CopyDirectory, @CopyFile, @CreateDirectory, @DeleteDirectory, @DeleteFile, @DirectoryEmpty, @DirectoryExists, @FileExists, @BrowseForFile and @BrowseForFolder

There has been a number of CDFs etc for dealing with finding files etc in DFW.CDF's are well and good but important functions like this should be dealt&nbsp; with by&nbsp;DataEase directly.In 2275 we have included the following DEOS fu...

Product: Dataease [{8}]FIVE. Written by DataEase 15/07/16 at 16:04:24

DataEase 8.5.0.2288 - OLEDB updated and fixed to cover DFD 5.x, DFW 6.x, DFW 7.x, DE8.5

As part of our DataEase Infrastructure program have we restored/fixed/finished the OLEDB Provider and Consumer so it will read/write to DataEase itself.The DataEase OLEDB Consumer and Provider was first developed during the DFW 6.x development...

Product: Dataease [{8}]FIVE. Written by DataEase 15/07/16 at 16:09:45

DataEase 8.5.0.2291 - GetCurrent("OSVersion") and GetCurrent("OSInfo") added.

New keywords to GetCurrent added to make it possible to find out what Operating system you are running and if the operating system is x64 or x32.GetCurrent("OSVersion") will return the version of your operating systems. Due to changes and limi...

Product: Dataease [{8}]FIVE. Written by DataEase 15/07/16 at 18:10:08

DataEase 8.0.2325 - Optional Wrappers added to HTMLEdit, WebField and Advanced Webfield

Webfield, Advanced WebField and HTMLEditor has been around since DE 8.0 and has been a great addition to DFW. However these features will now be used for many new area...

Product: Dataease [{8}]FIVE. Written by DataEase 15/07/16 at 18:34:05

DataEase 8.5.2364 - jsBridge between WebFields and PRISM added to enable WebForms

WebFields was one of the earliest features added to DataEase 8 and they have been a great additions.As everything else the more you integrate and use them the more yo...

Product: Dataease [{8}]FIVE. Written by DataEase 16/07/16 at 05:14:01

DataEase 8.5.0.2450 - Command to create shortcuts and pin/unpin them to Taskbar, Start Menu, Desktop added to DEOS

We made a pledge when we started redeveloping DataEase that we would use DataEase for everything including making DataEase in it. And we have stood by it. Where previous owners have used DataEase very little with the excuse that it didn't...

Product: Dataease [{8}]FIVE. Written by DataEase 05/08/16 at 20:54:28

DataEase 8.5 and Migration.... from DFW 5.12

It is no secret that we are not great believers in the art of migration. We have written many an article debating it and with the insight we have acquired into the architecture of DataEase for Windows our recommendation will still go far in developing...

Product: Dataease [{8}]FIVE. Written by DataEase 05/08/16 at 21:13:22

LegEasy4DOS and Pritners - MX80/IBM Proprinter

The built in Printer Engine in LegEasy4DOS is tuned to the standard DOS matrix printer of DataEase for DOS &nbsp;which is Epson MX80. Epson MX80 is compatible wi...

Product: LegEasy DOS. Written by DataEase 08/08/16 at 08:59:31

DataEase 8.5 - New Function : Alert() - Simple Message function like Message (Command DQL) Ver 8.5.0.2453)

Nothing is more useful when you "debug" code than a simple message box that pop up and give you feedback.In DQL this has been there since forever but in Derivation/ Action etc. there has never...

Product: Dataease [{8}]FIVE. Written by DataEase 08/08/16 at 11:36:42

DataEase 8.5 - Wait():Function and Timer():Event Where and When?

DataEase 8.x is an evolutionary developed project where we feed into our development model the experiences learnt earlier in the project. The project obviously started...

Product: Dataease [{8}]FIVE. Written by DataEase 10/08/16 at 09:44:20

LegEasy4DOS Professional - Print Margins and Raw (ver. 1.0.0.2455)

You guys are moving ahead so fast it is hard to keep up with you. In the latest version we have implemented full 16M memory capability as well as Margins On Printers (...

Product: LegEasy DOS. Written by DataEase 10/08/16 at 15:32:19

Re:LegEasy4DOS Professional - Print Margins and Raw (ver. 1.0.0.2455)

is there anything I can do in the advanced DEOs config and autoexec to get better performance?Do I need&nbsp;LOW = ONXMEM = 16 XMSstill?Thank you...

Product: LegEasy DOS. Written by Rainer 11/08/16 at 08:40:08

Re:Re:LegEasy4DOS Professional - Print Margins and Raw (ver. 1.0.0.2455)

Definitely not ;-)It is now default....

Product: LegEasy DOS. Written by DataEase 11/08/16 at 13:02:13

LegEasy4DOS Professional - How to run on Windows 2008R2 and Windows 2012 Server (Ver. 1.0.0.2464)

A lot of you want to run LegEasy4DOS Professional on a sever to host virtual sessions etc.&nbsp;As you already might know - Servers are much more security oriented than a workstation.The first problem you are going to run into is IE En...

Product: LegEasy DOS. Written by DataEase 18/08/16 at 11:55:51

LegEasy4DOS Professional - New Release with Printer Timout and Server 2008R2/2012 (Ver. 1.0.0.2464)

We have now released the "long" awaited version that Support Windows Server&nbsp;2008R2 and 2012. If you get the message above, simply follow the instructions and you...

Product: LegEasy DOS. Written by DataEase 18/08/16 at 18:02:04

DataEase and Windows 2012R2 Server (SMB1, SMB2 & SMB3)

Micorsoft do a lot of interesting stuff to improve performance on their servers but invariably it is detrimental to traditional software that is based on file sharing.We have written many articles on this but this is...

Product: Dataease [{8}]FIVE. Written by DataEase 20/10/16 at 09:33:58

FINAL 8.5 with highlights like Actions Info/Alphabetical RE-Layout and improved Migration (Ver 8.5.1.2674)

You might have thought it was a little quiet on the blog lately but rest assured that it is not down to us being idle.We have been working on the final release of 8.5 when at the same time the work on 8.6 has been going at full blast. One of th...

Product: Dataease [{8}]FIVE. Written by DataEase 04/03/17 at 19:45:21

Re:FINAL 8.5 with highlights like Actions Info/Alphabetical RE-Layout and improved Migration (Ver 8.5.1.2674)

These are really good improvements.&nbsp;But, we also need full details in the Status &gt;&gt; ImportsRight now we only have Import Name,&nbsp;File Size, DOS File.I am not sure what we can get out of this....&nbsp;...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 10/03/17 at 16:08:24

New Sample : ExecDQL, LabelExecDQL, MemoExecDQL Showcased and explained!!!

Download Sample! Not all of us has got to grips with the concept of ExecDQL so we have taken some...

Product: Dataease [{8}]FIVE. Written by DataEase 17/03/17 at 17:09:04

Re:New Sample : ExecDQL, LabelExecDQL, MemoExecDQL Showcased and explained!!!

this is all very nice.Does it work with "any"&nbsp;as well?&nbsp;Examplefor PERSONAL with ( Austritt &gt;= data-entry Field1 or Austritt = blank ) and Eintritt &lt;= data-entry&nbsp;Field1&...

Product: Dataease [{8}]FIVE. Written by Rainer 17/03/17 at 21:12:27

Re:Re:New Sample : ExecDQL, LabelExecDQL, MemoExecDQL Showcased and explained!!!

Of course. You ca do anything you can in "traditional" DQL and then some. It is however very awkward to include tags that [{any ERFASSUNG with ( Tag = Field1 and MANR = PERSONAL MANR ) BewegungsartNR}] So the best cause of action is...

Product: Dataease [{8}]FIVE. Written by DataEase 19/03/17 at 20:31:09

License terms and enforcement from April 5th 2017

It is no secret that license enforcement in DataEase has been very much a gentlemen's agreement. Some time back we started sending out warnings when a license was...

Product: Dataease [{8}]FIVE. Written by DataEase 05/04/17 at 11:49:28

Revised Sample - How to automatically generate Export DQL's and export all data in Application!

Downlaod Revised Sample! Hi. Sorry for the "long winded" reply. The short answer to your question...

Product: . Written by DataEase 03/07/17 at 19:25:28

Command line options DataEase for Windows 8.5 and 8.6

As part of the work with 8.6 we have brushed up on the Command line options of 8.x. A lot of the changes was actually done in 8.5 and is already available so we choose to publis...

Product: Dataease [{8}]FIVE. Written by DataEase 30/07/17 at 15:28:27

Troubleshooting Network Slowness - SMB and Oplocks again

1. IntroductionThe Server Message Block (SMB) Protocol is a network file sharing protocol, and as implemented in Microsoft Windows is known as Microsoft SMB Protocol. The set of message packets that defines a partic...

Product: Dataease [{8}]FIVE. Written by DataEase 06/11/18 at 15:27:49

LegEasy4DOS 1.4 and Printing PCL5 and Landscape.

One of the news in the MLU update to LegEasy4DOS 1 - 1.4 - is that it now also support PCL5 (HP LaserJet) native. You have always been able to use RAW mode to pri...

Product: LegEasy DOS. Written by DataEase 26/01/19 at 21:39:58

DE9 - Preview of the new Zebra style for subforms and the new subform definition process.

DataEase Subform has been untouched since the dawn of time and it was high time to...

Product: DataEase 9 Developer. Written by DataEase 04/10/19 at 13:56:04

DE9 - Dataease 9 Developer BETA - First startup, registering and login. Featuring new Welcome Application.

...

Product: DataEase 9 Developer. Written by DataEase 15/11/19 at 21:05:01

Re:DE9 - Dataease 9 Developer BETA - First startup, registering and login. Featuring new Welcome Application.

in de 8.5 I saw Clean option when choosing the style of a new application.&nbsp;de 9 beta proposes even Apple style ...&nbsp;macOS or iOS ? not watchOS for suresee the video to forecast possible Apple style in the nearest future</...

Product: DataEase 9 Developer. Written by Ihor Zakharchenko 24/11/19 at 16:12:42

Re:DE9 - Dataease 9 Developer BETA - First startup, registering and login. Featuring new Welcome Application.

I observed an issue of de 9 pro on a&nbsp;laptop which works under win 10 with&nbsp;Russian regional and language settings. the problem may be in "special" origins of that "russian" OS. But! the fact shows that Ukraine is a huge market for DataEase p...

Product: DataEase 9 Developer. Written by Ihor Zakharchenko 26/11/19 at 07:21:02