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

Support::

any



Parameters


Returns/Result


Examples


Reference

any

Type

Relational Operator

Purpose

The any operator selects the first record in a related table that matches the current record being processed. Since any returns the value from just the first related record, it is typically used when you are accessing the one side of a many-to-one relationship.

Syntax

any TABLENAME | RELATIONSHIP

 [named "UNIQUE RELATIONSHIP NAME" ]

 [with ( selection criteria) ] FIELDNAME ;|.

Returns:

The specified value from the first matching record in the related table. The type of value returned is the same as that of the specified field.

Usage:

The any operator can be used to:

Example

for FAMILY MEMBERS ;

list records

any MEMBERS LAST NAME in order ;

FIRST NAME;

DATE OF BIRTH.

end

 

This script tells DataEase: (1) Select all the FAMILY MEMBERS records, (2) for each record selected from the FAMILY MEMBERS table, list the LAST NAME from the (one) related MEMBERS record, and (3) list the first name and birthdate of each family member. The output, sorted by LAST NAME, might look as follows:

 

 

Last Name

First Name

Date of Birth

Adams

Will

09/23/60

Adams

Becca

04/28/90

Adams

Annalee

08/12/63

Albert

Roland

12/07/48

Albert

Rhonda

12/10/78

Albert

Lori

06/27/82

Albert

Kay.

11/03/50

...

...

...

 

See Also


On the forum about any

exporting - Has anyone been able to make this work?

I require an output file in Excel format from my DQL procedure. At the Print window I select Excel and enter a filename but when I try and open the resultant file with Excel (2 different versions) or the other piece of software that requir...

Product: DataEase for Windows 7.x. Written by Peter Birney 20/08/13 at 12:44:05

Re:exporting - Has anyone been able to make this work?

Yes, I have in the past many times. Exporting to CSV always works. What is that you are trying to do ? Regards Arul Fish4Support, 335 Goldhawk Trail, Scarborough, ON M1V 4G2, Canada Tel(Canada): 647-930-6497 | Tel...

Product: DataEase for Windows 7.x. Written by Jeyarajah Arulrajah 20/08/13 at 15:20:57

Re:exporting - Has anyone been able to make this work?

It's a very good reason why all of this stuff has been removed from DE8. It is a little like WebPublisher... A lot of promise and a lot of disappointment after a lot of work. 1. It does work, but it is part of the same library as the PDF...

Product: DataEase for Windows 7.x. Written by DataEase 20/08/13 at 13:43:11

Re:Re:exporting - Has anyone been able to make this work?

He is trying to use the Export to Excel functionality in 7.x not CSV export from Form. Export from DQL has been a big problem as we all know throughout the DFW era. Something that was so natural and simple in DFD became a problem with no...

Product: Dataease [{8}]FIVE. Written by DataEase Account 20/08/13 at 15:57:15

Re:Re:Re:exporting - Has anyone been able to make this work?

My DQL is in this format:- for Table A for Table B for Table C list records some fields from Table A some fields from Table B some fields from Table C end end...

Product: Dataease [{8}]FIVE. Written by Peter Birney 23/08/13 at 10:06:48

Re:Re:Re:Re:exporting - Has anyone been able to make this work?

The problem with DFW and DQL is that the DQL in many ways is a "fraud". It was implemented retrospectively and in contravention of how the new PRISM was designed. A DQL with List records is an emulation of the real multivi...

Product: Dataease [{8}]FIVE. Written by DataEase 23/08/13 at 12:59:41

Re:Re:Re:Re:Re:exporting - Has anyone been able to make this work?

I managed to get it to work by writing my data to a flat file and exporting the contents of that single file. Thanks for your help Mr D. ...

Product: Dataease [{8}]FIVE. Written by Peter Birney 29/08/13 at 09:08: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 , 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

Is there any difference in the syntax of the function MemoReplace used in a button or using MemoExecDQL?

Use this text in a button on the form order. This works as it should.SetValue("DQL_Nr" ,"104") + Wait(0.1) + MemoExecDQL( DQL ,"2","","","","") +Wait(1) + MemoReplace(settings,"[{filename}]",GetVar("VarSt...

Product: Dataease [{8}]FIVE. Written by Tor Nerland 12/11/14 at 09:42:53

Re:Is there any difference in the syntax of the function MemoReplace used in a button or using MemoExecDQL?

The syntax on a button and in a DQL is different but only in how you reference the column and when/where.In a form you will always have the PRISM column available but in a DQL it depends on where in the DQL you try to address it.1. Do yo...

Product: Dataease [{8}]FIVE. Written by DataEase 12/11/14 at 10:53:54

form open related layout more than 1 to view = no fire Setanything() on return data to

Getting on Getting on ok with De8, but currently struggling to get SetColor() or SetState() to fire without hitting save.On the database I'm using, if I lookup (form open related) from my order form, select the...

Product: Dataease [{8}]FIVE. Written by Simon B 17/02/15 at 10:23:18

Re:form open related layout more than 1 to view = no fire Setanything() on return data to

A little sample that show what you want is the best way to get a good response. We can't sit down and re-create this ourselves, and I don't think any of the users will have time to do that either.But in General:Each row in a multi-reco...

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

Re:Re:form open related layout more than 1 to view = no fire Setanything() on return data to

Thanks for the info. I found the operator but cannot get it to return any value. Could it be a limitation in the beta (sample) version I am using. I haven't purchase the complete software yet. Trying to decide if I can do the Lookup function and S...

Product: Dataease [{8}]FIVE. Written by Lisa 19/02/15 at 18:40:34

Re:Re:Re:form open related layout more than 1 to view = no fire Setanything() on return data to

Hi again Lisa. No, it is not the Beta. The Beta status is just “pro-forma” due to big changes in the Database logic but not related to this. The problem is that you are fooled by this “lookup field” malarkey. Forget about...

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

Re:Re:form open related layout more than 1 to view = no fire Setanything() on return data to

i said I'd done a test, I thought it 'd put some code up first to see if there was something glaringly obvious.  My mistake not just uploading it.Open attached database DEMO 01.  Username and password are blank.  Open 'orderform'...

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

Re:Re:Re:form open related layout more than 1 to view = no fire Setanything() on return data to

What would life be like if we couldn't find a reason to tell you off Simon ;-)DataEase 8.x create new apps from Templates. The default template contains a lot of "rubbish" because it is the best way to promote new features (from a demo viewpoi...

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

Re:Re:Re:Re:form open related layout more than 1 to view = no fire Setanything() on return data to

Thanks for the help. The zip file was exactly what I needed. Any chance I can get a sample Sub-Form file? We enter into sub-forms to generate billing statements and payroll. An example from you would be very helpful. Next step is to purchase the...

Product: Dataease [{8}]FIVE. Written by Lisa 21/02/15 at 11:28:44

Re:Re:Re:Re:form open related layout more than 1 to view = no fire Setanything() on return data to

Hi Simon. Just so you don't think we ignore you ;-)In general, I can say that you have a tendency to make simple stuff slightly "complex".....The combination of PRISM logic and GUI logic can get entangled if you rely on the firing in a...

Product: Dataease [{8}]FIVE. Written by DataEase 21/02/15 at 11:54:36

Re:Re:Re:Re:Re:form open related layout more than 1 to view = no fire Setanything() on return data to

Thank you :)I look forward to seeing how changing field colours SHOULD be done :DI think me making simple stuff slightly "complex"is down to not having instructions/rules to follow so winging it and also using the forum until i find some...

Product: Dataease [{8}]FIVE. Written by Simon B 24/02/15 at 16:52:51

Re:Re:Re:Re:Re:Re:form open related layout more than 1 to view = no fire Setanything() on return data to

Glad you agree ;-)One thing takes the other and suddenly we have a long chain of workarounds....he,heYou will find that we have updated the Help for all new functions on our website since we last spoke. We will soon add a runnable samp...

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

I CANT OPEN DATAEASE ANYMORE!!!!

MY LICENSE KEY EXPIRED? WHEN WANT TO USE WITH OLD VERSION IT COME OUT LOW MEMORY. PLEASE SOLVE THIS METHOD ISSUE....

Product: Dataease [{8}]FIVE. Written by Mohd Sedik Zakaria 17/09/15 at 04:27:54

Re:I CANT OPEN DATAEASE ANYMORE!!!!

Good Morning Mohd. It is not your license key that has expired but your Beta software. Please download the latest version&nbsp;of the Beta software or use one of the non expiring versions of the Beta from below: <a...

Product: Dataease [{8}]FIVE. Written by DataEase 17/09/15 at 05:15:57

Does anyone know how to calculate elapsed time? Such as for a time card for employees. DE8.5

Does anyone know how to calculate elapsed time? Such as for a time card for employees. I'm learning&nbsp;DE8.5 Beta.I'm basically trying to set up a time card form for my employees to put in time started then time ended to go home and have the...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 17/09/15 at 19:10:26

Re:Does anyone know how to calculate elapsed time? Such as for a time card for employees. DE8.5

Download Sample! Hi Kevin NY. Time computation in DataEase is very straightforward...

Product: Dataease [{8}]FIVE. Written by DataEase 18/09/15 at 06:43:57

Re:Re:Does anyone know how to calculate elapsed time? Such as for a time card for employees. DE8.5

Thanks for your quick reply. But I can't seem to open the sample it says page not found?...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 21/09/15 at 12:04:39

Re:Re:Re:Does anyone know how to calculate elapsed time? Such as for a time card for employees. DE8.5

Sorry. It had been removed by mistake. Try again....

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

Re:Re:Re:Re:Does anyone know how to calculate elapsed time? Such as for a time card for employees. DE8.5

Works like a charm (or DEforDOS)...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 06/10/15 at 02:32:17

Does anyone know when DE 8.5 will come out of Beta?

Does anyone know when DE 8.5 will come out of Beta? And be a full blown product.I've been working with the Beta and I like it! &nbsp;Reminds me of the old days (well almost)....

Product: . Written by Kevin O'Donnell 27/10/15 at 12:11:57

Re:Does anyone know when DE 8.5 will come out of Beta?

The honest answer to that is NO!8.2 is the version that brought DFW up to "scratch" and as such the last of an era...8.5 is the version where we drag DataEase up from the doldrums and into modern times and beyond.In hindsight w...

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

Availability of any trial version ?

Hi, I've been asked about resurrecting one of my old Dataease 6 Windows apps for a client so I was hoping to see about downloading a trial version of something that will work in Win7 .&nbsp; I tried the "trial" link in the website but it returns a pag...

Product: Dataease [{8}]FIVE. Written by Dave Houston 27/10/15 at 18:01:13

Re:Availability of any trial version ?

The trial link on the product page was "outdated".It has now been updated so it will generate the trial key.You can also generate a trial key via this link:http://www.dataea...

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

Has anyone created a smartphone app that links back to a Dataease application

Has anyone created a smartphone app that links back to a Dataease application? I'd be very interested in hearing and or seeing any if they are out there wither in iOS or Android....

Product: DataEase Generation 3. Written by Kevin O'Donnell 02/11/15 at 15:30:16

Re:Has anyone created a smartphone app that links back to a Dataease application

We have created several, and it will be much easier to do when we release the DataEase server next year.We are also working on a framework to make it easier to package a DataEase Web App as an app both for iOs and Android.You can devel...

Product: DataEase Generation 3. Written by DataEase 03/11/15 at 11:13:19

Document Management? Is anyone using a document management system with any DE? is it integrated?

Document Management? Is anyone using a document management system with any DE? is it integrated?I'm looking to build an app with 8.5 and would like to connect it in some way with a document management system. If any one has any experience or...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 23/11/15 at 13:27:16

Re:Document Management? Is anyone using a document management system with any DE? is it integrated?

Document management span so much...1. Do you have a Document Management system already that you want to integrate with?2. What kind of documents do you want to manage?It is quite straight forward to make a Document Management syste...

Product: Dataease [{8}]FIVE. Written by DataEase 23/11/15 at 15:41:14

Re:Re:Document Management? Is anyone using a document management system with any DE? is it integrated?

What i'm dealing with here on this one is a transportation/trucking company which generates a lot of bills of lading, inventory/packing lists, signed delivery receipts, workers time sheets, and invoices that are sent out off of the accounting system....

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 23/11/15 at 15:49:22

Re:Re:Re:Document Management? Is anyone using a document management system with any DE? is it integrated?

Do you want to create the documents directly in DataEase or do you want to import them as PDFs etc....

Product: Dataease [{8}]FIVE. Written by Christine Porteous 24/11/15 at 14:39:43

Re:Re:Re:Re:Document Management? Is anyone using a document management system with any DE? is it integrated?

Primarely it would be importing .pdf's.&nbsp; Then secondary would be to generate them out of DE...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 24/11/15 at 14:41:41

Is there any way to set Size to fit (Display attribute box) to be checked as default?

Is there any way to set "Size to fit" (Display attribute box) to be checked as default?I'm building a lot of forms with a lot of fields its making me a little crazy to click around to get this box checked.&nbsp;A default 'check' would be...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 25/11/15 at 14:22:57

Re:Is there any way to set Size to fit (Display attribute box) to be checked as default?

SizeToFit is set automatically when you insert a field etc.But when you re-size the object this checkbox is automatically switched off as you have manually re-sized it....

Product: Dataease [{8}]FIVE. Written by DataEase 25/11/15 at 14:56:18

Re:Re:Is there any way to set Size to fit (Display attribute box) to be checked as default?

In my copy(of&nbsp;8.5Beta) when i create a new field (insert?) in a 'form' it does not automatically 'size to fit'. &nbsp;Maybe my version is buggy?Is there a way to reset that default somewhere?...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 25/11/15 at 15:00:22

Re:Re:Re:Is there any way to set Size to fit (Display attribute box) to be checked as default?

We can't get it to behave "your" way whatever we do.Can you send us a Sample Application that behave the way you describe. Please create it from scratch (small) and check that it behave as you say.SizeToFit is not part of the style, it...

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

Re:Re:Re:Re:Is there any way to set Size to fit (Display attribute box) to be checked as default?

On second thought, what do you do when you create a field?Do you drag it to size or do you simply click in the form?Common Document Object OperationsThe operations common to all Document objects are: Creating Do...

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

Re:Re:Re:Re:Re:Is there any way to set Size to fit (Display attribute box) to be checked as default?

What do you...it's the human element causing the problem! &nbsp;I guess i just have a bad habit of dragging when i place the new field on the form. Causing it to de-select the 'size to fit' box.Now that is about the easiest fix I've ever come a...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 01/12/15 at 15:40:37

Re:Re:Re:Re:Re:Re:Is there any way to set Size to fit (Display attribute box) to be checked as default?

Dear Kevin.No apologies needed. We constantly need to challenge the reasoning behind how things work. Our problem is that we get so used to how things work that one forget the "problems".We are currently moving into a phase were our ma...

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

has anyone built an app in 8.5 that will handle inventory control?

Just curious if anyone has built an 8.5 app that will handle parts in and out. The usual inventory control. &nbsp;I'm about to start one would be open to see how others are handling.RegardsKevin...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 28/03/16 at 13:54:25

Re:has anyone built an app in 8.5 that will handle inventory control?

Yes....full inventory with stock control, wholesale, point of sale, purchase module, photos etc. etc.Contact me for further details...

Product: . Written by Josef Vella 29/03/16 at 09:35:55

Re:has anyone built an app in 8.5 that will handle inventory control?

Some screen shots, system fully in DataEase, multi user and implemented @ various customers. Main Screen Stock Card Sample <img...

Product: Dataease [{8}]FIVE. Written by Josef Vella 29/03/16 at 09:52:52

Re:Re:has anyone built an app in 8.5 that will handle inventory control?

Thanks for your postings I will take some time and look at these..Kevin...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 31/03/16 at 12:59:23

Re:Re:Re:has anyone built an app in 8.5 that will handle inventory control?

Dear JosefHow can I contact you ? e-mail?tks...

Product: Dataease [{8}]FIVE. Written by afonso santos 10/04/16 at 21:25:09

Re:Re:Re:Re:has anyone built an app in 8.5 that will handle inventory control?

vella.josef@gmail.com...

Product: Dataease [{8}]FIVE. Written by Josef Vella 11/04/16 at 06:12:56

Error 400 is still a problem. Any solutions yet??????

[@EOF@]...

Product: . Written by Henry Gondorf 13/04/16 at 09:52:22

Check security level of any document

Hi there,is there a way to easily check (e.g. an export of properties) the security level for every document, without going through all of them and click on Document -&gt; Security?Regards,George...

Product: Dataease [{8}]FIVE. Written by George Washington 13/04/16 at 10:55:24

Re:Check security level of any document

Sadly no. There is a ticket on including the Status Tables to include buttons and all properties for each object type. Why security level was deemed "un-interesting" when this was implemented is not documented and hence will have to be left open for s...

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

I am currently running DataEase 5.62. Will I need anything more than DataEase 8.5, to migrate my data into DataEase 8.5?

[@EOF@]...

Product: . Written by Kelion Kopp 27/11/16 at 14:59:52

I am currently running DataEase 5.62. Will I need anything more than DataEase 8.5, to migrate my data into DataEase 8.5?

[@EOF@]...

Product: . Written by Kelion Kopp 27/11/16 at 14:59:52

Re:I am currently running DataEase 5.62. Will I need anything more than DataEase 8.5, to migrate my data into DataEase 8.5?

No.You only need to open the application in DE85 and it will automatically detect that it is a DE 6.x application.If the application has been developed on a windows that use , as decimal separator you should do back on the initial menu...

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

Can somebody please eleborate on window types and how to create modal forms ? Many Thanks....

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Luigi Faso 27/12/16 at 20:12:40

Re:Can somebody please eleborate on window types and how to create modal forms ? Many Thanks....

To start with you can have a look at this sample.http://www.dataease.com/DG3_BlogList/?ParentID=0000000314&amp;field1=0000000314...

Product: Dataease [{8}]FIVE. Written by DataEase 28/12/16 at 12:17:46

Re:Re:Has anyone created a smartphone app that links back to a Dataease application

"and it will be much easier to do when we release the DataEase server next year."Is this something that is out now (Dataease Server) ?...

Product: DataEase Generation 3. Written by Kevin O'Donnell 23/01/17 at 19:20:31

Re:Re:Re:Has anyone created a smartphone app that links back to a Dataease application

Yes and No.It will be part of the next release of DataEase.It is divided in two products.DataEase Development Server which is for developing and testing Web Solutions and then DataEase Deployment Server for Deploying and Publis...

Product: Dataease [{8}]FIVE. Written by DataEase 27/01/17 at 13:55:49

In your CRM app, a number of fields prompt the user to insert some text i.e enter Subject. As I would like to prompt the user in asimilar way in an input form, how can I achieve the same result! Many thanks

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Luigi Faso 20/04/17 at 12:24:26

Re:In your CRM app, a number of fields prompt the user to insert some text i.e enter Subject. As I would like to prompt the user in asimilar way in an input form, how can I achieve the same result! Many thanks

In DE85 you have virtual editable fields which means you can have fields as "data-entry field" anywhere - even in reports and on the form object directly that is not saved.You can use these fields in a number of way. You can store the value in...

Product: Dataease [{8}]FIVE. Written by DataEase 20/04/17 at 15:31:34

Changing Many Records to Fewer Records.

Hi All,I was wondering if there is a way to change many records to fewer records. The first table shows 21 records of a Ford F-150 ranging in years from 2015 to 2017 with two&nbsp;different engine sizes. Would it be&nbsp;possible to create a...

Product: Dataease [{8}]FIVE. Written by Bolt-on-Trailers 03/05/18 at 17:33:52

Re:Changing Many Records to Fewer Records.

Looks like both images didn't upload. Here is a pic of both tables. Many records on top and fewer records on bottom.&nbsp;...

Product: Dataease [{8}]FIVE. Written by Bolt-on-Trailers 03/05/18 at 17:53:41

Re:Re:Changing Many Records to Fewer Records.

Easy peasy ;-)You simply need to create a copy of&nbsp; your table and then write a DQL along the lines.define "vMake" text .define "vModel" text .define "vYear" text .define "vEngineLiters" . (as many of these as you need to d...

Product: Dataease [{8}]FIVE. Written by DataEase 03/05/18 at 22:13:46

Re:Re:Re:Changing Many Records to Fewer Records.

Thank you for your help. I really appreciate it.The following script seems to function but only displays the data. It does not enter any new records in&nbsp;NewTable&nbsp;define "vMake" text .define "vModel" text .define "vSub...

Product: Dataease [{8}]FIVE. Written by Bolt-on-Trailers 07/05/18 at 16:59:57

Re:Re:Re:Re:Changing Many Records to Fewer Records.

We could also simplify things. If I wanted to create&nbsp;just one record of all makes in the old table would the script look like this?&nbsp;define "vMake" text .For OldTable ;list recordsMake in order .if Make = vMake then<...

Product: Dataease [{8}]FIVE. Written by Bolt-on-Trailers 07/05/18 at 17:35:07

Re:Re:Re:Re:Re:Changing Many Records to Fewer Records.

Try thisdefine "vMake" text .For OldTable ;list recordsMake in order .if Make not = vMake thenenter a record in NewTablecopy all from OldTable .end .vMake...

Product: Dataease [{8}]FIVE. Written by Peter Birney 08/05/18 at 17:38:21

Re:Re:Re:Re:Re:Re:Changing Many Records to Fewer Records.

"if Make != vMake or Model != vModel or year !=vYear or EngineLiters != vEngineLiters then"Thanks Peter and sorry Bolt-On-Trailer...You can tell that HTML and JavaScript is a big thing in the upcoming DE9/DataEase 4 Web/LegEasy 4 Web.....

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

Re:Re:Re:Re:Re:Re:Re:Changing Many Records to Fewer Records.

Thank you DataEase and&nbsp;Thank you Peter for&nbsp;your help. The following does work and creates one record of each make in the new table. It still however displays the data on screen&nbsp;and I have to scroll through to the end&nbsp;in orde...

Product: Dataease [{8}]FIVE. Written by Bolt-on-Trailers 09/05/18 at 16:26:36

Re:Re:Re:Re:Re:Re:Re:Re:Changing Many Records to Fewer Records.

To simply not display it on the screen, remove the following two lines:-list recordsMake in order ....

Product: Dataease [{8}]FIVE. Written by Peter Birney 10/05/18 at 09:44:13

Re:Changing Many Records to Fewer Records.

Oops!"To simply not display it on the screen, remove the following two lines:-list recordsMake in order ."Be careful not to pour the baby out with the bathwater now. If you do this you won't get Make in order and hence the...

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

Re:Changing Many Records to Fewer Records.

For the more interested of our readers we can add the following:The problem Mr. Trailer has is the "singular" reason for us looking into ExecDQL.The DQL in DFW is flawed in many ways and one main one is that you NEED list records to...

Product: Dataease [{8}]FIVE. Written by DataEase 10/05/18 at 10:47:56

Re:Re:Changing Many Records to Fewer Records.

Oooops indeed!That just shows the dangers of typing something off the top of one's head as you are "walking out of the door"!If I remember correctly, old age and senility notwithstanding, if Make was indexed there was a way of specify...

Product: Dataease [{8}]FIVE. Written by Peter Birney 10/05/18 at 13:29:15

Re:Re:Re:Changing Many Records to Fewer Records.

Just tested and that most likely worked in DFD but not in DFW....&nbsp;One of the many small "insignificant" differences that made migration from DFD to DFW a nightmare.......

Product: Dataease [{8}]FIVE. Written by DataEase 10/05/18 at 17:32:31

AnyLookup()/Timer Event and general info...

Download Sample <span style="color: rgb(192, 80...

Product: DataEase 9 Developer. Written by DataEase 29/01/20 at 17:25:45

AnyLookup() to multiple forms

AnyLookup() is another function that I have been testing.I have a test setup, so field names do not always match data I am looking up, but the field type is always correct, ie text.I am getting differing results with this. Some forms the lo...

Product: DataEase 9 Developer. Written by Paul Cheeseman 03/02/20 at 15:25:11

Re:AnyLookup() to multiple forms

Hi again Paul.One example I have used that worksAnyLookUp(Concat(COUN_LookupForm1,"?Disp_Counter=",COUN_Counter*," "), "DISP_Address1")AnyLookUp(Concat("ADV_Wea...

Product: DataEase 9 Developer. Written by DataEase 04/02/20 at 14:21:40

Re:Re:AnyLookup() to multiple forms

When you word it like that, passing a string within a string, it makes more sense. Escape strings make it interesting!Changing the test fields to this for the text field based lookups works:AnyLookUp(Concat(COUN_FormName ,"?CUST_Unique=/'",...

Product: DataEase 9 Developer. Written by Paul Cheeseman 04/02/20 at 16:27:32

Re:Re:Re:AnyLookup() to multiple forms

One interesting oddity, when I apply this to a lookup for an address field, where its a concat(many, address, fields) on multiline display, it shows the address text twice like this!MyAddressMyTownMyCountyMyAddress MyTown<...

Product: DataEase 9 Developer. Written by Paul Cheeseman 04/02/20 at 16:45:32

Re:Re:Re:Re:AnyLookup() to multiple forms

When you know about this you very quickly start to use keys that are numerical as it save you a lot of hassle ;-)filters like this is very much how you do things on the web. Free relationships like this first appeared in Dataease Generation 3...

Product: DataEase 9 Developer. Written by DataEase 04/02/20 at 17:17:49

Re:Re:Re:Re:Re:AnyLookup() to multiple forms

Is there a way to stop this firing twice? I do remember somewhere on the site it was mentioned, I just cant find it!...

Product: DataEase 9 Developer. Written by Paul Cheeseman 05/02/20 at 15:02:57

Re:Re:Re:Re:Re:Re:AnyLookup() to multiple forms

Two questions:What version of DE9 are you using now?How are you calling it? I.e. button, virtual field, OML?There was a lot of events that fired not just twice but even more than that but we hope and believe that we have managed to red...

Product: DataEase 9 Developer. Written by DataEase 05/02/20 at 16:05:48

Re:Re:Re:Re:Re:Re:Re:AnyLookup() to multiple forms

Version 9.0.0.3995Its from a field, with this as derevation: AnyLookUp(Concat("CRM_CustomerFile?CUST_Unique=/'",SESS_CustomerUnique ,"/' "), "CUST_MailAddress")Shows fine on a normal lookup, but anylookup() duplicates. All the oth...

Product: DataEase 9 Developer. Written by Paul Cheeseman 05/02/20 at 16:09:33

Re:Re:Re:Re:Re:Re:Re:Re:AnyLookup() to multiple forms

1. Your versions is ages old. Download the latest version.2. WHen you say it doubles do you get the result double in the field? MyNameMyName? or does it call he lookup twice.Can you attache the entire derivation in the field as well as a p...

Product: DataEase 9 Developer. Written by DataEase 05/02/20 at 16:32:09

Re:Re:Re:Re:Re:Re:Re:Re:Re:AnyLookup() to multiple forms

CRM_CustomerFile Field derevation: CUST_MailAddressconcat ( CUST_Address1 , if ( CUST_Address1 = blank , "" , "" ) , CUST_Address2 , if ( CUST_Address2 = blank , "" , "" ) , CUST_Address3 , if ( CUST_Address3 = blank , "" , "" ) , C...

Product: DataEase 9 Developer. Written by Paul Cheeseman 05/02/20 at 16:54:43

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:AnyLookup() to multiple forms

[@EOF@]...

Product: DataEase 9 Developer. Written by Paul Cheeseman 05/02/20 at 17:07:28

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:AnyLookup() to multiple forms

So you lookup the concatenated field into another form and then it suddenly has double the value.Sorry for being so slow ;-)...

Product: DataEase 9 Developer. Written by DataEase 05/02/20 at 17:53:18

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:AnyLookup() to multiple forms

Yep thats right. I just did the same on another set of forms, same types of fields and it did the same....

Product: DataEase 9 Developer. Written by Paul Cheeseman 05/02/20 at 18:02:39

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:AnyLookup() to multiple forms

The only thing I can think is your version is too old. It predates anything we ever released and we have no control of what is in it.Download the latest version from Download here.if you have some problem in new version, make a sample...

Product: DataEase 9 Developer. Written by DataEase 05/02/20 at 18:58:34

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:AnyLookup() to multiple forms

This is now on the newest version, I did that yesterday.I'll mess around with it a bit more today, then make an upload for you.Thanks...

Product: DataEase 9 Developer. Written by Paul Cheeseman 06/02/20 at 10:09:24

Re:AnyLookup() to multiple forms

Hi again Paul.Can't wait to see what cause this. I'm convinced its not the functionality itself now so it must be something cyclic.I guess we will both laugh when we finally figure it out.PS! I removed 20 re: from the reply...maybe we...

Product: DataEase 9 Developer. Written by DataEase 06/02/20 at 10:40:08

Re:Re:AnyLookup() to multiple forms

Ok, I have made a small demo, two forms. CustomerFile has two customers, Display form has one advert each. Same lookup, same issue.Hopefully this one will be an obvious fix?...

Product: DataEase 9 Developer. Written by Paul Cheeseman 06/02/20 at 15:46:37

:AnyLookup() to multiple forms BUG! Found

Hi Paul.Thanks for not giving up on us.No smoke without fire...Luckily there was a couple of trigger points so our QA doesn't have to fall on their sword just yet....

Product: DataEase 9 Developer. Written by DataEase 06/02/20 at 16:41:42

Re::AnyLookup() to multiple forms BUG! Found

OK at least there is a pointer :)Not used those memo fields yet, we do have some that will benefit from the conversion. Easy steps for now though!Giving up on you is not an option! We want to make this conversion and update work. There i...

Product: DataEase 9 Developer. Written by Paul Cheeseman 06/02/20 at 17:28:43

Re:Re::AnyLookup() to multiple forms BUG! ?It is now fixed in DE9 over 9.0.0.4496

Thank you to Paul for finding and pointing out this bug to us.It is now fixed in DE9 over 9.0.0.4496...

Product: DataEase 9 Developer. Written by DataEase 07/02/20 at 13:48:05

On the blog about any

Changed Functionality in 8 - <New Relationship> can now create any relationship! (Ver. 8.0.0.1017)

Some times one is allowed to be egotistical...especially if one is in charge of DataEase Development...One thing that annoy me beyond belief is unnecessary restrictions and obstacles, and to be honest DFW have had its fair share of them....

Product: Dataease [{8}]FIVE. Written by DataEase 03/11/11 at 11:29:34

New Function in 8 - SetFocus() - Move the cursor/focus to any Field/Button (Ver. 8.0.0.1147)

When the SetValue() function is implemented in a couple of days, the Keystroke CDF lovers will get competition. To be able to direct the next action/input from the result of a previous have been a wished for functionality in DataEase "for ever", but for...

Product: Dataease [{8}]FIVE. Written by DataEase 26/10/12 at 09:43:11

Re:New Function in 8 - SetFocus() - Move the cursor/focus to any Field/Button (Ver. 8.0.0.1147)

I know that we can already set any Tab order we want. I use this to fill in a form. I have tricked it a little so that it can follow different paths through my form depending on the starting point, but what I am struggling with is to "point" on the right...

Product: Dataease [{8}]FIVE. Written by David Mills 01/11/12 at 16:21:41

New Function in 8 - ToText() - Converts any DataEase field/function value to Text (Ver 8.0.0.1171)

A lot of our seasoned developers know that what you see is not always what you get. Internally DataEase converts values freely between formats, but not always. Especially when you use functions and allocated fields directly you might get peculiar resul...

Product: Dataease [{8}]FIVE. Written by DataEase 30/11/12 at 07:32:37

New Function in 8 - SetValue() - Setting a value in any field from a button or another field (Ver. 8.0.0.1177)

The new Set functionality have now come full circle with SetValue().Traditionally DataEase functions have been limited to being just that...functions i.e. something that do a job and return the result.In DataEase 6.x we introduced a sc...

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

Re:New Function in 8 - ToText() - Converts any DataEase field/function value to Text (Ver 8.0.0.1171)

Can I have serial # for Dataease 8 Trial Ver. please...

Product: Dataease [{8}]FIVE. Written by Wahid DeWan 13/12/12 at 23:36:59

Re:Re:New Function in 8 - ToText() - Converts any DataEase field/function value to Text (Ver 8.0.0.1171)

Sorry, there is no trial serial for DataEase 8 at the moment....

Product: Dataease [{8}]FIVE. Written by DataEase 16/12/12 at 19:41:35

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

ChinEase - How to get your DataEase to "speak" Chinese or any other language.... (CharacterSet/CodePage)

Download Sample We have done a lot of different fixes and improvements since we took over DataEase Devel...

Product: Dataease [{8}]FIVE. Written by DataEase 13/07/17 at 11:44:29