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

Support::

all



Parameters


Returns/Result


Examples


Reference

all

Type

Relational Operator

Purpose

The all operator selects every record in a related table that matches the current record being processed.

Syntax

all TABLENAME|RELATIONSHIP

 [named "UNIQUE RELATIONSHIP NAME" ]

 [with ( selection criteria) ] FIELDNAME;|.

 

Returns

The specified value from every matching record in the related table. The type of value returned is the same as that of the specified field. For example, if you are selecting text fields, the returned value is text.

Usage

The all operator can be only used to specify report output items in a list records command. It cannot be used to specify selection criteria.

Example 1

for MEMBERS with TOTAL DUE > 100 ;

list records

LAST NAME in groups ;

all RESERVATIONS RESERVATION ID ;

all RESERVATIONS TOTAL DUE .

end

 

This script tells DataEase: (1) Select all the MEMBERS records that have a TOTAL DUE greater than $100, (2) find all these members' reservations in the related RESERVATIONS table, and (3) for each record selected from the RESERVATIONS table, list the RESERVATION ID and TOTAL DUE.

The output from this script, arranged in groups by LAST NAME (from the MEMBERS table), might look as shown below:

 

 

Last Name

Reservation ID

Total Due

Albert

00197

4,760

 

00359

3,220

Anders

00015

4,420

 

00421

2,290

 

00298

2,480

Anderson

00077

4,320

Archer

00085

4,796

Bennington

00002

5,662

Bickford

00141

2,800

 

00356

3,650

Christino

00139

5,450

 

Example 2

Example 2 demonstrates how you can use the all operator to access information from two or more related tables on the same relationship level. The relational operators can also be used to navigate from one table to a third table (which is not directly related) by using an intermediate relationship, as shown in the sixth line of the script.

 

for ACTIVITIES

list records

ACTIVITY in groups ;

all CLUB ACTIVITIES CLUB NAME ;

all MEMBERS LAST NAME ;

all MEMBERS all FAMILY MEMBERS FIRST NAME .

end

 

This script tells DataEase: (1) Select all the ACTIVITIES records and group them by ACTIVITY, (2) find all the related records in CLUB ACTIVITIES and list the name of each club that offers the activity, (3) find all the related records in MEMBERS and list the last name of each member who favors the activity, and (4) find all the related MEMBERS records (for each ACTIVITIES record), and for each MEMBERS record, find all the related FAMILY MEMBERS records and list the value in the FIRST NAME field.

The output from this script, arranged in groups by ACTIVITY, might look as follows:

 

Activity: Baseball

 

 

Club Name

Last Name

First Name

Playa Blanca

Connelly

John

Cancun

 

Erin

Punta Cana

 

Patrick

Huatulco

 

Mary

St. Lucia

Rada

Amanda

Columbus Island

 

Jerome

 

 

Clarenct

 

Ruggiero

Donato

 

 

Anna

 

DiLorenzo

Lawrence

 

 

Daniel

 

 

Gregory

 

 

Mary Anne

 

Stomboulis

Christos

 

 

Helen

 

Walsh

Ivan

 

 

Emma

 

 

Charlotte

 

 

Ann Marie

 

See Also


On the forum about all

installation error Visual C++ 2005 redistrubable

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Kermit Yost 04/08/13 at 15:06:27

Re:installation error Visual C 2005 redistrubable

This means there is a conflict with another version of the VC 2005 distribution package. What version of Windows are you running?...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 05/08/13 at 07:05:56

Install in DE8

One of my customer was trying to rebuild his application and found out there is a problem with the install in DE8. This is what he was doing, and I tried it with my database and it is happening too. You can try the following: <...

Product: Dataease [{8}]FIVE. Written by Arul 08/08/13 at 22:52:35

Re:Install in DE8

Hi Arul. The install stuff is not new in DE8. The problem is installing of Data and have been there at least in all 7.It is a nightmare to install Data, and it also assumes that the table name is the “same” as the Form name if you...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 08/08/13 at 22:54:00

Re:Re:Install in DE8

Yes, after changing to single user it worked fine. Thanks...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 14/08/13 at 21:06:30

Re:Re:Re:Install in DE8

DE8 devlopment is "two tier".&nbsp;First priority is to add new functionality that we feel is missing to make the product "complete".Second priority is to fix key functionality that has been broken for a long time.<br...

Product: Dataease [{8}]FIVE. Written by DataEase Development 15/08/13 at 08:51:04

Functionallity DFD / DFW

I am an user of DFD 4.53 since years. I migrated on of my apps like you told on your homepage and the result is not bad! The problems are the printoutput is the biggest problem. You told me that the...

Product: Dataease [{8}]FIVE. Written by Rainer 01/09/13 at 20:57:46

Re:Functionallity DFD / DFW

the printoutput is the biggest problem. You told me that the DE8 Reporter will come later this year. Will it be part of the DQL and can I then make new layouts from old DQL-reports procedures? <p style="margin-...

Product: Dataease [{8}]FIVE. Written by DataEase 03/09/13 at 15:35:27

Re:Re:Functionallity DFD / DFW

to 1. ok thank you to 4. I soved it with if(myfield = blank, current date, myfield) that works to2 and 3 I send an email with an example. ...

Product: Dataease [{8}]FIVE. Written by Rainer 03/09/13 at 22:27:51

spell date and number in all countries

[@EOF@]...

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

DataEase Installation version 8.1

There's a way to start installation wizard without any user prompt? I hope that I can use a parameter for the product key or for the installation directory. I&nbsp; have to distibute automatically the product to many users. ...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 04/02/14 at 09:15:26

Re:DataEase Installation version 8.1

SImply install your multi-user DataEase on your computer and zip down the catalogue&nbsp;<span style="background-color: rgb(255, 255, 255);...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 04/02/14 at 10:08:46

How to show/hid a button based on all fields filled?

I'm a bit stuck, I want to hide a print button in Dataease 8 until all the fields are filled ?...

Product: Dataease [{8}]FIVE. Written by Charmaine 12/02/14 at 09:29:42

Re:How to show/hid a button based on all fields filled?

Download Sample There is plenty of ways to do this, but none of them are a ?one-click-shop?. I guess the question here is how many fields are we...

Product: Dataease [{8}]FIVE. Written by DataEase 12/02/14 at 12:36:57

Calling MemoExecDQL From a Button

Second attempt for this entry.I am trying to create a button to call a DQL saved in ExecDQLStore under DQlNr 001MemoExecDQL( any ExecDQLStore with (DQLNr = "001") ,"" ,"","" ,"" ,"") ....

Product: Dataease [{8}]FIVE. Written by Graham Brown 09/03/14 at 17:48:31

Re:Calling MemoExecDQL From a Button

Hi Graham.You can't use ANY in a derivation. When using MemoExecDQL in a form you need to first lookup the DQL you want to use in a Virtual Memo and then execute it.This is a Data/Programming crossover where you store the DQL's as data...

Product: Dataease [{8}]FIVE. Written by DataEase 10/03/14 at 09:33:05

Calling a ExecDQL from with an ExecDQL

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by 25/03/14 at 12:58:36

Problems when I try to install a table within including data for a table

There are serious problems when you try to install a table from another database (same version 8) checking including data for Table. The installation ends normally but when I try to open the table installed, DataEase crashes and ends with an Access Vi...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 27/03/14 at 14:52:31

Re:Problems when I try to install a table within including data for a table

The problem is Locking.&nbsp;In DE7 and DE8 you can run a Local version of DE with Locking and this is enabled by default in DE8.To be able to install a Table with Data you need to run DE as standalone. The best way to do this is simpl...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 28/03/14 at 18:45:30

Re:Calling a ExecDQL from with an ExecDQL

ExecDQL is just a function so you can simply call it like this.retval := MemoExecDQL(any DQLStore with DQLNr=006,"","","","","") ....

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 28/03/14 at 18:50:56

Re:Re:Problems when I try to install a table within including data for a table

I’ve tried to import a table in standalone mode as suggested ad it’s work fine.But there’s a very serious problem when I try to import a very large table that contains more than 1.500.000 records. (DBM) DataEase crashes with a GPF – Access viol...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 16/04/14 at 14:39:29

Re:Re:Re:Problems when I try to install a table within including data for a table

Problem with import of large tables (.dbm) import has been fiexed in 1533....

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

Change Style on all the tables in the DB

There's a way to change the style on all the tables of the DB? I've changed the style into the application preferences but it will applied only when I create a new table and not on all the tables installed on the DB. I have to change it manually on ev...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 28/04/14 at 16:28:34

Re:Change Style on all the tables in the DB

Styles in DFWworks the following way.1. The best way to restyle all forms with the same style is to re-define the existing style. If you have created a new style called something else, simply save it with the same name as the existing style in...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 29/04/14 at 08:42:15

Re:Change Style on all the tables in the DB

I have initially crete a db with STYLE=none so I don't have any file with .STY into the directory. I try to create a new style with name=default and put it into application preferences but nothing happened. How can I do now?...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 29/04/14 at 10:31:22

Re:Re:Change Style on all the tables in the DB

Styling is done on each object. If you create a form/Table from Style NONE it means no Style.Styling is a inheritance hierarchy, so if an object is not styled it is not styled and hence it cannot inhert a style later.You have to give t...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 02/05/14 at 09:47:31

How to reorganize all tables from a DQL.

I perform every month a massive load of data into the DB and It’s very important to reorganize all the tables before starting the loading procedures.(There’s a way to reorganize all tables via DQL in a single command? – I would like to start t...

Product: Dataease [{8}]FIVE. Written by Marco 07/05/14 at 11:05:02

Re:How to reorganize all tables from a DQL.

The possibilities in DE8 is vast compared to earlier versions, but a lot of it is still to be unlocked for existing users….I guess I can start the unlocking a little here: The following script would reorganize all the tables in your da...

Product: Dataease [{8}]FIVE. Written by DataEase 07/05/14 at 11:06:56

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

Delete all records in a form

While trialing a conversion from DE5.12 to&nbsp;8 I have left a couple of fields out. &nbsp;How do I delete all records? &nbsp;Cannot find the delete function in DQL. &nbsp;Beginning to prefer the Dos&nbsp;system I have been using for 25 years....

Product: Dataease [{8}]FIVE. Written by Ian Stockbridge 23/08/14 at 12:43:51

Re:Delete all records in a form

Hi IanDeveloping in a windows environment is a totally different experience that in dos :)To delete all records in a form:File &gt; New Procedure&nbsp;Type: delete recor...

Product: Dataease [{8}]FIVE. Written by Josef Vella 23/08/14 at 13:19:10

Re:Re:Delete all records in a form

Josef,Have found the DQL commands, I had been looking in the reports, hence my initial question.Do as you say, but when I press the Check Script it comes up with a blank screen. &nbsp;Have looked at all the options and also cannot find t...

Product: Dataease [{8}]FIVE. Written by Ian Stockbridge 23/08/14 at 14:47:16

Re:Re:Re:Delete all records in a form

CHeck Script is the Gear (1) and the Run button is the man running (2). You can also hit F2 to check script and F4 to run (user view)....

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup. 24/08/14 at 10:39:11

Re:Re:Re:Re:Delete all records in a form

Thank you sorted that one....

Product: Dataease [{8}]FIVE. Written by Ian Stockbridge 24/08/14 at 17:14:21

Slow calculations on 2011 Small Business Sever with using SMB2

DataEase 8.2I have a DataBase that contains a CashBook with @200,000 recordsIn the cashbook there are two fields Credit &amp; DebitsWithin a Form I have two lookup fields linked by relationships that need to calculate <e...

Product: Dataease [{8}]FIVE. Written by 17/10/14 at 12:15:23

Re:Slow calculations on 2011 Small Business Sever with using SMB2

It is hard to diagnose this without sitting on top of the problem.For a very long time it was a speciality of DataEase support to work on the notion of conflicts, registry settings, patching and wizardry&hellip; I used to work on DataEase suppo...

Product: Dataease [{8}]FIVE. Written by DataEase 20/10/14 at 19:10:12

Re:Re:Slow calculations on 2011 Small Business Sever with using SMB2

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Graham Brown 22/10/14 at 13:28:50

Exit from dataease automatically

I have some automatic procedures that runs during the night but those procedures doesn’t close dataease application.Since version 6.52 I use :a := ExitDataEase() .a := Keystrokes("_enter") .DataEase 8 doesn’t close the appl...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 31/10/14 at 07:32:10

Re:Exit from dataease automatically

I have used the same coding that you have shown and it works - Are you running your procedure from another procedure, is it being called from an unterminated block etc.I would check again that the procedure that is closing your database is bein...

Product: Dataease [{8}]FIVE. Written by Peter Birney 31/10/14 at 20:57:28

Re:Exit from dataease automatically

One of the big news in DataEase 7.0 was the conversion of Borland C++ to Microsoft Visual C++. This was higly necessary since Borland C++ was de-supported etc.Borland C++ had its own DLLs and functions for most windows functions so the behavio...

Product: Dataease [{8}]FIVE. Written by DataEase 01/11/14 at 09:58:16

Re:Re:Exit from dataease automatically

I tried your code marked in blue :1) If I run the procedure simply open the procedure via catalog it works.2) If I run the procedure via scheduled task it doesn't work and reply to me "Ok to close "Application name" ? and if I click "yes" appe...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 03/11/14 at 09:16:25

Re:Re:Re:Exit from dataease automatically

I had a similar request from a client.&nbsp;All I did was created a 3rd party utility to open DataEase, run the procedure, wait for the DataEase to finish running the procedure, when procedure completes, there will be message like "OK to close....

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 05/11/14 at 02:15:31

Re:Re:Re:Re:Exit from dataease automatically

Thank you for this. Unfortunately I cannot install 3rd part software without a license and a specific approval by my company.&nbsp; If it works with your script could you please send it to me by e-mail or upload the file in your website? (marco.marche...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 05/11/14 at 11:31:46

Re:Re:Re:Re:Re:Exit from dataease automatically

Hi Marco,May be I did not explain myself properly. This utility is created according to customer application/specification. i.e. it is chargeable consultancy.That is why I even pointed out which software I use. And you can use the same s...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 05/11/14 at 14:25:11

Re:Re:Re:Re:Re:Re:Exit from dataease automatically

We have now added ExitDataEase("Silent")One thing you have to make sure of is that you call Exit in the right place. In my example I did it in a wrong place i.e. in the middle of a loop and this can cause problems.Only call exit when Da...

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

DataEase 6.53 Installation Question

I see in your installation document, you have mentioned about the configur.dat file;&gt;&gt;Make sure that you also copy it to the program&nbsp;catalogue, as the one in the shared catalogue and in the program catalogue need to be the sa...

Product: LegEasy 6 Windows. Written by Jeyarajah Arulrajah 13/11/14 at 15:28:38

Re:DataEase 6.53 Installation Question

It is just a way to get around deleting files.&nbsp;Deleting files when you install applications is not "good" management. it works the same both ways.Crazy installation and amazing that it wasn't "fixed" until 7.0...

Product: LegEasy 6 Windows. Written by DataEase 13/11/14 at 17:18:25

Problem with Importing/Installing Table with Form in ver. 8.2.0.1679

Suddnly version 8.2.0.1679 is blocking the TDF file during import from another Database (Install). You no longer get the option of installing the table.arvid...

Product: Dataease [{8}]FIVE. Written by Arvid 14/11/14 at 12:07:54

Re:Problem with Importing/Installing Table with Form in ver. 8.2.0.1679

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 Tech Sup. 14/11/14 at 12:09:57

Default font in DataEase 8 - Segoe UI needs to be installed, fixed in 8.5

Hello George.The problem here is straight forward.DE8 use the new default font for Windows 7/8 which is SegoeUI. If a workstation doesn't have this font, Windows will default to the "closest" font which is a dubious affair.DE8 does...

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

Network installation DE8.2 (group)

Hallo out there,were can i find SETUP informations for networkinstallation (Microsoft Server Network) for DE8.2 ?Thank you for informations.Markus...

Product: Dataease [{8}]FIVE. Written by Markus 17/04/15 at 13:56:24

Re:Network installation DE8.2 (group)

Hi Markus.There is no setup necessary. Just put the application on the server and install DataEase 8 on each client, then simply run the application.Make sure you use Opportunistic Locking as locking options.Cheers!...

Product: Dataease [{8}]FIVE. Written by DataEase 17/04/15 at 14:52:17

Re:Re:Network installation DE8.2 (group)

Following on from this, is dename and depath still required locally these days?&nbsp; Thanks....

Product: Dataease [{8}]FIVE. Written by Simon B 22/04/15 at 10:49:39

Re:Re:Re:Network installation DE8.2 (group)

DENAME has not been necessary since 7.0 as DataEase read the ID from the machine.However DENAME was re-instated in 7.2 as there was problems if one rean multiple Sessions on one computer without running them on a local drive. Then all users wo...

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

DataEase Separate Install for Each Version

One thing I was thinking about, as a developer managing many clients. Some already using&nbsp;DataEaseFull-8.2.0.1619 in production.When I install&nbsp;DataEaseFull-8.2.0.1700 on the same computer, it overwrites the previous.It would be...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 25/06/15 at 01:19:04

Re:DataEase Separate Install for Each Version

You can do this already, simply copy the installed DataEase to a different catalogue then the installed one. It will still work.Very few people have the same challenge as you I am afraid, so I think we will keep it as it is. If we started to t...

Product: Dataease [{8}]FIVE. Written by DataEase 25/06/15 at 10:54:11

Re:Re:DataEase Separate Install for Each Version

Thank you for showing&nbsp;this technique. I thought DE8 register information into Windows registry. So, I never tried copying into a different folder.&nbsp;I will try this, and this is enough for now....

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 25/06/15 at 12:53:54

Re:Re:Re:DataEase Separate Install for Each Version

It does register some information in the registry but is is insignificant. You will see that the copied version and the installed version is sharing the same DataEase.ini etc. I think it only use the Registry to make itself interesting as it seriously...

Product: Dataease [{8}]FIVE. Written by DataEase 26/06/15 at 09:28:04

Inserting GROUPS manually in QBM

Hi again Arul.As they said in the British Navy.... "The lesser of two weevils.."I must of course admit that it was not very wise to even try to fix QBM and DQL, but we did an attempt in 7.2 (had to revert) and we did an attempt again i...

Product: Dataease [{8}]FIVE. Written by DataEase 26/06/15 at 09:45:33

Application Utilities Install

I wanted to install a form from a migrated DE652 database and the DE8 install utility didn’t recognise any of the forms in the migrated database. I decided that maybe I should backup and restore the migrated database but I could not find it under Appl...

Product: Dataease [{8}]FIVE. Written by Henry Gondorf 14/10/15 at 08:20:47

Re:Application Utilities Install

Hi.It will install forms from a Migrated Database. They are no different than any other DE8 files.I suspect that you try to install a form/dql from a 6.52 database. When you migrate the DE6.x app it will be re-created in a different ca...

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

Re:Application Utilities Install

After downloading the latest Beta version 1918, I still cannot install a form from a migrated DE652 database. I can import data from a “migrated” .dbm file but not install.RegardsHenry Gondorf...

Product: Dataease [{8}]FIVE. Written by Henry Gondorf 20/10/15 at 13:46:24

Re:Re:Application Utilities Install

Dear Mr. Gondorf. We are sorry that you are still struggling. It is very hard to judge what is going wrong, as you give us very little information other than it goes wrong&hellip; 1. What is the 6.52 migrated to? Is it mi...

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

DataEase Schema Challenge

A ChallengeSince DE8x can sing and dance and do all things possible, it must be capable of producing a report such as :-for System database(x)list recordsField1, field name, Type, Text Options, Required, Indexed, Unique,&nb...

Product: Dataease [{8}]FIVE. Written by Kensington 28/10/15 at 14:57:49

Re:DataEase Schema NO Challenge...;-)

DataEase is "self-documenting" as you have Status Tables that contain all the information about Tables, Documents, DQL's, Derivations, OML etc..The only thing missing is Code on Buttons which...

Product: Dataease [{8}]FIVE. Written by DataEase 28/10/15 at 17:28:36

Re:Re:DataEase Schema NO Challenge...

Lovely.....Thanks a million...

Product: Dataease [{8}]FIVE. Written by Kensington 28/10/15 at 17:41:34

install on Win7 64

i tried to install 8.5, but it does not work. dease is not startingand I can only end bei cancelling the task....

Product: Dataease [{8}]FIVE. Written by Rainer 31/01/16 at 11:25:29

Re:install on Win7 64

The full version...

Product: Dataease [{8}]FIVE. Written by Rainer 31/01/16 at 11:29:22

Re:install on Win7 64

What happens i.e. how far do you get?Does the installation go OK; but you can't start the product or does the installation fail?What version of DataEase 8.5 do you try to install?Have you checked if your virus software get a hi...

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

Re:Re:install on Win7 64

I installed 8.5.0.2131 Full. I just got a new Noteboot W7 64 bit. Now I install it also on my old XP 32 Bit. on the old everything is all right.on the new&nbsp;the instllation is ok,&nbsp;but when I start it, I cannot even put the liecence numb...

Product: Dataease [{8}]FIVE. Written by Rainer 31/01/16 at 20:14:30

Re:Re:Re:install on Win7 64

I just installed it on Window 10 Pro 64-bit.No issues.I wonder it could be related to permission. Do you have enough permission on your Windows 7 machine?...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 01/02/16 at 02:27:25

Re:Re:Re:install on Win7 64

We have no other reports on this being a problem, and we have tested install on all kind of devices from 7 inch Windows Pads through to big multi processor, multi-screen systems with all kinds of SSD to normal HDDs and on Windows XP through 7,8,10 Ser...

Product: Dataease [{8}]FIVE. Written by DataEase 03/02/16 at 08:54:23

Re:Re:Re:Re:install on Win7 64

I know found out what was wrong.I am the user with adminrights in W7. I installedlt it butit did not work.I deinstalled it and installed it with the funktion "execute&nbsp;as Admin". but it still did not work propaly.I deinstalled...

Product: Dataease [{8}]FIVE. Written by Rainer 03/02/16 at 12:01:38

Re:Re:Re:Re:Re:install on Win7 64

MS Security VOODOO ;-)Glad you fixed it,&nbsp;Cheers!...

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

Predefined printers on RDRRxAAA for all the users

In the RDRRxAAA.ini there's a section for the predefined printers but I have to add a section for each client in the network.There is a way to setup the same printer configuration for all the user in the network?In the example below the config...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 15/02/16 at 13:41:49

Re:Predefined printers on RDRRxAAA for all the users

This is very much close to the first feature added to the DE8.0 project and I guess that it was such a big step forwards at the time that it was left as it is (except for the GetCurrent()/SetCurrent() feature.As this is very much featured on t...

Product: Dataease [{8}]FIVE. Written by DataEase 15/02/16 at 13:58:31

Re:Re:Predefined printers on RDRRxAAA for all the users

Thanks. anyway I tried to use "setcurrent" but it seems to me that it doesn't works. I tried also in a DQL. I use DE 8.2. There's something wrong? (see figure)Anyway "Getcurrent" return to me Blank even if the printer is inserted into the ini f...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 15/02/16 at 14:55:42

Re:Re:Re:Predefined printers on RDRRxAAA for all the users

Sorry, Set/Get Application printers was first introduced in early 8.5 and then it was expanded to SetCurrent() when this function was introduced late in 8.5<a href="http://www.dataease.com/DG3_BlogList/?ParentID=0000000243&amp;field1=000000024...

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

Concat all the occurences of one field in a related table

Hi there,here's the problem. I have the form "Conductors" that is related to the form "Offer_row". A "Offer_row" record can have one or more records related in the "Conductors" table. Any record in "Conductors" has a field called "Color". I hav...

Product: Dataease [{8}]FIVE. Written by George Washington 23/03/16 at 10:43:06

Re:Concat all the occurences of one field in a related table

Yes.&nbsp;You don't explain very well if you are wanting to show this in the subform, or if Offer_Row is a Main form record.It is easier if it is a Main Form as you will be able to insert the result of the EXECDQL directly in the field.<...

Product: Dataease [{8}]FIVE. Written by DataEase 24/03/16 at 08:48:27

Re:Re:Concat all the occurences of one field in a related table

Well, it worked, but messed up other things. So I went for a button that opens a related form. The thing with the email is now fixed....

Product: Dataease [{8}]FIVE. Written by George Washington 25/03/16 at 17:17:37

Re:Re:Re:Concat all the occurences of one field in a related table

This shouldn't mess up anything except....The execdql is part of the context of the form and we have showed a couple of times how you can change the constraint of a relationship (selection) via executing an Execdql.As much as this is a...

Product: Dataease [{8}]FIVE. Written by DataEase 25/03/16 at 18:26:33

I need to install Dataease 5.53 on a different pc

We have it installed on an aging pc. I can access the menu from another pc and attempt to install it but none of the disks I have seem to work. We need to do something the backups won't do us any good if the pc dies and we can't install the program on...

Product: Services. Written by eric polanco 13/05/16 at 16:10:09

Re:I need to install Dataease 5.53 on a different pc

5.x is not very "clever" you can simply zip it down and unzip it on another computer. No need to install it "properly".The problem might rather be that it won't run on modern computers, so you will need to run it on a x86 (32 bit) Operating sy...

Product: Services. Written by DataEase 13/05/16 at 17:03:35

Re:Re:I need to install Dataease 5.53 on a different pc

Thanks so much for the help. What do you mean by zip it down and back up to another pc. I have been playing with it on an xp machine. I can access the menu thru the DE16M shortcut but not the entire program to perform entries etc. I copied the dease f...

Product: Services. Written by eric polanco 13/05/16 at 17:07:19

Re:Re:Re:I need to install Dataease 5.53 on a different pc

ZIp it down in file explorer (WIndows)Right click on it and choose Send To/Zipped Folder or something like that (XP is a long time ago for me)....

Product: Services. Written by DataEase 13/05/16 at 17:12:44

Re:Re:Re:Re:I need to install Dataease 5.53 on a different pc

Same results I can access the menu of the program. I can pull reports and access the data, but not the program itself. I can't perform any of the day to day functions....

Product: Services. Written by eric polanco 15/05/16 at 16:14:40

Application Utilities Install

Good Afternoon DataeaseUsing DATAEASE 8.5.0.2222,D85-PICKERIN000-28809 with Share local database switched off and strategy = single user.Trying to install single documents from a LegEasy 6.53 Database into Dataese 8....

Product: Dataease [{8}]FIVE. Written by KEV 23/05/16 at 13:47:16

Re:Application Utilities Install

Hi Kev.A lot of things has changed since then...1. You don't have to run single user etc. to install documents any more. You can run in Normal mode. Switching the locking strategy in the "outer" DataEase will not change the locking str...

Product: Dataease [{8}]FIVE. Written by DataEase 23/05/16 at 14:59:21

Re:Re:Application Utilities Install

Many thanks for your prompt reply.The reason I was going down this path with single document install was I could not migrate my application – see my recent post 17/5/16 MIGRATION ERROR 6.53 to 8.5.0.2222.Hope you can help....

Product: Dataease [{8}]FIVE. Written by KEV 23/05/16 at 15:14:32

Re:Re:Application Utilities Install

Hi again Kev.Upload your application on here as a hidden upload and we will have a look.There is so much "history" in old DataEase applications so sometimes you get caught out....DataEase has been a strong beliver in Migrations...

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

Re:Re:Re:Application Utilities Install

Hi again Kev.We have now looked at your application and we understand why you have struggled.There is something peculiar/corrupt in this application.&nbsp;Where dos it originate i.e. is it in-house development all the way or di...

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

Problems with Read/Write Error all the time in 6.53

Hi.I have just installed 6.53 on a new machine and it looks fine, but I get Read/Write Disk error all the time. It works fine if I hit ignore, but it is impossible as the message repeats itself 5-10 times before it will go away.Anyone...

Product: LegEasy 6 Windows. Written by Jonas Wilks 24/05/16 at 15:57:57

Re:Problems with Read/Write Error all the time in 6.53

Hi Jonas.LegEasy 6 Windows (6.53) is a little old fashioned in how it behaves.1. It need to be installed with full read/write rights on its program catalogue as it opens some file with read/write permissions. If it doesn't get this it...

Product: LegEasy 6 Windows. Written by DataEase 25/05/16 at 07:03:29

LegEasy4DOS Installation Problem

When trying to install LegEasy4DOS I am getting the error message 'Unable to register the DLL/OCX:RegSvr32 failed with exit code 0x3.'I have tried running it as Administrator and I have checked that RegSvr32 exists on my system.The syste...

Product: LegEasy DOS. Written by Peter Birney 14/06/16 at 09:23:56

Re:LegEasy4DOS Installation Problem

It is part of the LegEasy Connect which is not yet operational so you can simply ignore it. It shouldn't affect the operation of LegEasy 4DOS in any way.Plenty of other stuff that do that though ;-)Will publish another update tomorrow....

Product: LegEasy DOS. Written by DataEase 14/06/16 at 20:07:42

A small timer application in practice.

Hello Dataeaseforum!I realized a little idea with the timer function:I wanted a small info window (with more detailed information from the subrecord) opens when you stand with your mouse over a sub form line. But after a short delay! If one mo...

Product: Dataease [{8}]FIVE. Written by Markus 22/06/16 at 17:10:43

Re:A small timer application in practice.

Hi Markus.Brilliant.The TImer() function is so much more than one first imagine.We use it for delayed action i.e. when you want to execute functions one after the other as well.We also use it to reformat a manipulated wi...

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

mixed installation

Is it possible to mix L4D workstations/clients and XP 32 bit workstations/clients&nbsp;with "normal" installation in one network?...

Product: LegEasy DOS. Written by Rainer 10/08/16 at 09:21:06

On the blog about all

New Function in 8 - FormRefresh() - Refresh form so all active objects are displayed correctly... (Ver. 8.0.0.1132)

This is obviously an unnecessary function but we have created it anyway...;-)DataEase 7.x or aka. the "Flasher from Romford", was flashing and blinking like mad. Every time you moved from one field to the next, it looked like it was going to ha...

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

Changed Functionality in 8 - Virtual Memo fields allowed - Greatest feature so far! (Ver. 8.0.0.1009)

On thing that amaze me when I work with DataEase for Windows, is how "moralistic" it is.If I bought a tool (most of you have stolen it, so you can't complain ;-) and paid good money for it, I would hate it, if it didn't do what I wanted, but in...

Product: Dataease [{8}]FIVE. Written by DataEase 24/10/11 at 11:40:35

DataEase 8 - Small Sample to show off SetState(),SetFocus(),SetColor(),SetLabelText() (Ver. 8.0.0.1281)

This is just a small sample to show off SetState() - &nbsp;Hiding/showing/disabling/enabling of fields/buttons and other GUI objects, SetFocus() - set focus on any field or button etc that you want to have the...

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

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

New Function in 8 - RefreshStatus() - Refresh all status/info tables (Ver. 8.0.0.1153)

New function that refresh the status/info tables in DE8.&nbsp;The Status Info tables have been a little cryptic, but we have now normalised them so that they are tables like every other DataEase table.You can create relationship with t...

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

Small Sample - ExecDQL() Show manipulation of Data/Form/Documents/AutoClose...

Download Sample One of the big news in DE8 is ExecDQL() and we are sorry that it hasn't been properly documented and promoted yet. Hopefully there is so muc...

Product: Dataease [{8}]FIVE. Written by DataEase 13/09/13 at 14:47:24

DataEase 8 - How to delete all the data in an application

We get a lot of strange requests and one we get quite regularly is how to delete all the data in an application.There is no "button" to hit so the way forward has really been to meticolously create a big DQL with delete records in ... for e...

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

The password change link code must manually be updated

When we did an update of the underlying Django web framework from 1.5.x to 1.6.x, the password change link has been update from 36 to 64 in length. This means that you manually have to change this code in your DG3 authentication module, since this is...

Product: DataEase Generation 3. Written by DG3 Development 21/01/14 at 11:55: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 - Encoding for prohibited characters implemented in all String Functions (Ver. 8.2.0.1600)

It has always been "Impossible" to include prohibited characters in DE derivation/scripts. Characters like New Line (CR), Tab and " (Quote) which are very useful to get in there, has been very difficult to shoehorn in.When I first started on D...

Product: Dataease [{8}]FIVE. Written by DataEase 18/08/14 at 18:27:12

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

New Sample - How to use a subform as a Dynamic Pick list for all your fields (Ver. 8.2.0.1686)

Download Dynamic Picklists SampleCTRL-F10,&nbsp;Dynamic Lookup, Open related, Lookup Fields, Multibox... So...

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

DataEase 8.5 - New Function: IndexUpdate() - Dramatically increase speed! (Ver. 8.5.0.1744)

IndexUpdate (8.5 onwards) IndexUpdate("Tablename") IndexUpdate("Switch") IndexUpdate("CustomerTable") IndxUpdtate("Off") RetVal := IndexUpdate("Quick")...

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

New Sample! Emulate OpenRelated (F10) to allow search in "related" form. (Many COOL functions)

Download Sample! WE have a lot of question about OpenRelated(F10) and why you can't break the filter and search freely in the related form. OpenRelated() is d...

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

CDF Re-invented! Calling all programmers!

Dear All.A lot of things going on that soon will be revealed, but one "early warning".We have had a look at the good old CDF interface that has fallen "fallow".&nbsp;Not everything is suitable to include in the standard functio...

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

Re:CDF Re-invented! Calling all programmers!

This is very good! That you opened up a DLL programming.Actually, I am not very good with C/C++. So, what I did was created an EXE file for a client to be used like a CDF.What it does in their application is, we will send a full postal addr...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 30/05/15 at 02:16:18

Re:Re:CDF Re-invented! Calling all programmers!

Another question I had is.Are we able to create DLL using C# and use it in DataEase?...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 30/05/15 at 02:27:27

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 - SetState(), SetStyle(), SetColor(), MoveObject() all now support wildcard (Ver. 8.5.0.2001)

New Features create New Demands....SetState(), SetStyle(), SetColor() and MoveObject() are between the most popular and besides ExecDQLClass the most used new features in DataEase 8.We very quickly realised that you needed to be able t...

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

Want to use DataEase to boil an egg? Timer Event finally introduced! (Ver. 8.5.0.2044)

Download Sample! Up to 8.5.0.2043 all actions in DataEase had to be triggered by an user. There was no way...

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

Re:Want to use DataEase to boil an egg? Timer Event finally introduced! (Ver. 8.5.0.2044)

Can this be used to trigger an Data import at the same time of the day each day of the week without user input?...

Product: Dataease [{8}]FIVE. Written by Edward Gordley 08/12/15 at 19:45:44

Re:Re:Want to use DataEase to boil an egg? Timer Event finally introduced! (Ver. 8.5.0.2044)

Yes, as long as DataEase is running and the form with the timer is loaded.Obviously if you close the form or you close DataEase the timer will stop running.If you want to make sure it is run, use Windows Scheduler and load DataEase dir...

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

DataEase 8.5.0.2428 - DeletRecords updated with Options to allow specific deleting without dialogue.

It is almost crazy that this feature took so long to join our function library.Nothing has been as annoying as deleting records in DFW.Personally I have been using ExecDQL("delete records in mytablw with ID=data-entry field1 .",ID) sim...

Product: Dataease [{8}]FIVE. Written by DataEase 16/07/16 at 06:27:35

LegEasy4DOS - format of Install files (INSTALL.DIN) in 4.x

FORM: install form FORMNAME from: FORMNAME.dba ; ex : install form CUSTOMERS from: custaaab.dba ; Now the form/table is installed so the next bit is data. New Table: <b...

Product: LegEasy DOS. Written by DataEase 10/08/16 at 13:39:14

New Sample: How to automatically open different external documents from DE 8.5 (Showcase)

Download Sample DataEase 8.5 is packed with new functionality but that is not much help if n...

Product: Dataease [{8}]FIVE. Written by DataEase 21/03/17 at 20:14:46

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

L4D - How to manually create a shortcut to an Application

One much loved feature in L4D is the ability to pin an application to Desktop, Start-Menu or/and Taskbar.This is a feature that Microsoft is not too happy about and in the last update of Wind...

Product: LegEasy DOS. Written by DataEase 14/11/19 at 17:04:30

Re:L4D - How to manually create a shortcut to an Application

insert de16m.exe dbname username userpswd and some parameters needed through slashes in Your autoexec.bat&nbsp;then switch off and on Your deviceand You will get de453 OS instead of windows or dos. if You wanna them to be visited by You...

Product: LegEasy DOS. Written by Ihor Zakharchenko 15/11/19 at 06:49:11

L4D - Auto Installation/Distribution demonstration Video

...

Product: LegEasy DOS. Written by DataEase 20/11/19 at 19:08:09

L4D - Creating New Application in L4D and why all apps are located in B:\

You can create a new application in any location on your computer. SImply add a name for your new application, browse to the location you want to use, and hit SAVE and the Session will be...

Product: LegEasy DOS. Written by DataEase 02/04/20 at 15:20:10