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

Support::

Functions



Parameters


Returns/Result


Examples


Reference

Functions

Type

Concept

Purpose

The 58 DataEase functions execute calculations, manipulate text, and perform other time-saving data-entry operations. There are nine groups of functions, briefly summarized below.

  • The if function returns one of two values based on its evaluation of a specified condition as true or false.

  • Date functions convert a date into a number representing the day, month, year, day of the week, or day of the year on which the specified date falls.

  • Spell functions convert a date or numerical value into its equivalent text value.

  • Time functions extract the hour, minutes, or seconds from a 24-hour format time value or assign the appropriate AM or PM suffix.

  • Text functions are used to concatenate, truncate, or manipulate a text value.

  • Financial functions calculate either the beginning value, end value, interest rate, installment amount, or number of payment periods for a financial transaction, given the values of the other four variables.

  • Scientific functions raise a base value to a power, derive natural and base 10 logs, or derive the square root of a value.

  • Trigonometric functions convert a numeric value into a value expressed in radians.

  • Math functions perform common mathematical rounding operations or return the absolute value of a specified numeric value. The random function generates a pseudo random number.

 

For a full explanation of any DQL function, see the entry listed under the function's name in this Language Reference.

See Also


On the forum about Functions

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

Problem with GetGlobal / SetGlobal functions while checking procedure .

See below  an example :....................................... .................................. ................................ ...........................

Product: Dataease [{8}]FIVE. Written by Luca 31/07/13 at 13:21:39

Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

Hmmm… This is a little headache. SetGlobal(), GetGlobal() is an internal function now not a CDF. And it is defined with “names” rather than numbers to make it more useful. SetGlobal(“MyVar”,MyValue) GetGloba...

Product: Dataease [{8}]FIVE. Written by DataEase 31/07/13 at 13:23:50

Re:Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

It's not a good idea to change how existing functions, etc, work, especially with such a commonly used function as this one.Could you not have given the internal version of this function a different name? e.g. GetVariable, or GetVar.Ther...

Product: Dataease [{8}]FIVE. Written by Adrian Jones 02/08/13 at 14:04:19

Re:Re:Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

Very good point Adrian and the time to correct it is now and the new name is GetVar()/SetVar().Luckily this is the only one, was worse when hole functionality was replaced like the Old Memo with the New memo or Lookup fields with Multi...

Product: Dataease [{8}]FIVE. Written by DataEase 02/08/13 at 14:34:42

Re:Re:Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

You can of course still use numbers and loop through them if that is what you want as DataEase automatically converts numbers to text when you use a variable, so in that use case there will be no difference....

Product: Dataease [{8}]FIVE. Written by DataEase 05/08/13 at 13:40:19

Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

SetGlobal()/GetGlobal() are now renamed to SetVar() and GetVar().You can now use the old CDF and the new functions in parallel.If you have used the the new internal format for SetGlobal()/GetGlobal() you will have to rename them in your...

Product: Dataease [{8}]FIVE. Written by DataEase 05/08/13 at 13:41:53

Re:Re:Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

Adrian Jones wrote: "There is also an advantage to having the number, as it means you can view the currently used values with a getGlobal ( number ), or with my Looper table of integers with getGlobal ( LoopNo ). Of course, if the...

Product: Dataease [{8}]FIVE. Written by DataEase 01/10/13 at 09:16:45

CDF / Custom Designed Functions

Hi AllIts been a while since I did anything with DFW (6.5 was probably the last release) .It looks like there is some interesting changes ahead and I will keep a close eye on things.We are long time NetPlus Developers which uses t...

Product: LegEasy 6 Windows. Written by Dave Rolph 29/11/13 at 11:49:11

Re:CDF / Custom Designed Functions

Hi Dave.I see that nobody has replied to you and since that is very dis-heartening I will ;-)Sadly I can't give you any good news. The GETFILEN.DLL that we use is the original one and it has the same "problem" as you describe.W...

Product: LegEasy 6 Windows. Written by DataEase 06/12/13 at 18:00:27

Re:Re:CDF / Custom Designed Functions

Thank you Mr DataEase ! We have now written a utility to get us round the problem and this works well.I am keeping a close eye on the movements at DataEase, sounds very promising !...

Product: LegEasy 6 Windows. Written by Dave Rolph 07/12/13 at 11:07:16

Missing functions in DE8 Catalogue Help

We have now updated the DE8 catalogue help so it will show all functions. We have also had a quick run through of the same function to make sure all of them contain atleast a minimum description on "usage".The Website in the DE8 Catalogue is u...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 12/09/14 at 18:58:02

Re:Missing functions in DE8 Catalogue Help

Got the same problem wtih setstyle() as i did with setcolor.  New form works, an existing form doesn't.So I've abandoned looking at that one.  I've got a perfect example of the earlier problem SETCOLOR which i'll send over in a few mo...

Product: Dataease [{8}]FIVE. Written by Simon B 15/09/14 at 09:55:20

Re:Re:Missing functions in DE8 Catalogue Help

Example emailed over, i've stripped out all other tables and dql's so it's nice and small....

Product: Dataease [{8}]FIVE. Written by Simon B 15/09/14 at 10:18:19

Re:Re:Re:Missing functions in DE8 Catalogue Help

Hi again Simon and thanks for the sample.The problem is not that the function is not working, but the way you apply it.Setfunctions including SetColor are manipulation functions and this is conceptually completely new in DataEase terms...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 18/09/14 at 07:36:14

Re:Re:Re:Re:Missing functions in DE8 Catalogue Help

Only just found this reply, not got a notification and never noticed it on the home pg, odd. Nevermind.  I understand what you're saying, I misunderstood the nature of how it SHOULD be used, I incorrectly took the virtual field example as a best...

Product: Dataease [{8}]FIVE. Written by Simon B 22/09/14 at 13:25:08

Problems with different functions in DE9 that doesn't work

The main issue was when we put in the ability to enter multiple adverts from multiple magazines, each of which has its own forms. This required a central “session” file to hold information from these forms, but related to the customer. This eventually...

Product: DataEase 9 Developer. Written by Paul Cheeseman 29/01/20 at 17:23:52

On the blog about Functions

New Functions in 8 - SetVar()+GetVar() - Time to take control!

As part of the DataEase for Windows restoration project we have come to a big omission in DataEase - Global Variables or transfer of information between processes if you like.It amazes us how many wishes, needs and wants from almost every user,...

Product: Dataease [{8}]FIVE. Written by DataEase 02/11/12 at 20:25:35

New Functions in 8 - MemoSetGlobal()+MemoGetGlobal() - Global array of memo values (8.0.0.1287)

We have now reached 19 Memo specific functions...puh!Memo has come to it's own in 8 and it is a little funny as they were so reviled in 7.Anyways...We and our 8 users have now used the different memo functions fo...

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

New Functionality - DE8 Console, functions: ConsoleCopy(), ConsoleShow() (Ver. 8.0.0.1323)

Download SampleIt is no secret that the ability to generate simple output, export, text, screen printing has been strongly missed in DFW since its c...

Product: Dataease [{8}]FIVE. Written by DataEase 05/07/13 at 11:49:53

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 8.2 - Variable number of Arguments added to functions (Ver. 8.2.0.1656)

Up to this version the number of arguments a function can take has been "fixed". If the function was originally defined with 0,1,2 arguments you would always have to include them all even if you didn't need them.As example we can use ExecDQL.<...

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

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! Part 2 advanced functions.

Download the full example here In this document we will concentrate on the supported function types, parameters and return types. We will show examples of all retu...

Product: . Written by DataEase Development 14/06/15 at 10:14:15