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

Support::

Symbols



Parameters


Returns/Result


Examples


Reference

Symbols are tools that clarify a script's meaning, perform basic math operations, and help retrieve data when you cannot recall the exact values you want a query to retrieve. The symbols listed below can be used in Field Derivation Formulas as well as in a DQL script.

There are four groups of DQL symbols as specified below:

  • Punctuation symbols are used to clarify, separate, and conclude various operations specified in a script. The double dash symbol precedes comments used to annotate a script.

  • Math symbols are used to perform arithmetic operations on numeric values.

  • Wild card symbols are used to specify unknown characters in selection criteria text values.

*(asterisk) represents any number of characters

? (question mark) represents a single character

~ (tilde) represents a sound pattern

 

For a full explanation of any DQL symbol, see its corresponding entry in this section. The symbols are presented first in the lexicon, beginning on the ne

See Also


On the forum about Symbols

incorrect display of cyrillic symbols in table view

While working in DataEase 8, I have fased a problem. Cyrillic symbols (ANSI Windows 1251) were displayed incorrectly, but only in table view. What can you suggest to fix this problem? Please, write, if you know, how to help....

Product: Dataease [{8}]FIVE. Written by gel63 09/08/13 at 08:33:17

incorrect display of cyrillic symbols in table view

While working in DataEase 8, I have fased a problem. Cyrillic symbols (ANSI Windows 1251) were displayed incorrectly, but only in table view. What can you suggest to fix this problem? Please, write, if you know, how to help....

Product: Dataease [{8}]FIVE. Written by gel63 09/08/13 at 08:33:17

Re:incorrect display of cyrillic symbols in table view

We are looking into it. It looks to be a character translation issue in Table View.We will investigate further and make a Fix Ticket....

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

Re:incorrect display of cyrillic symbols in table view

We have tested it now:Russia - 6 possible code pages:    case 855:       // Primary Russian DOS    case 866:       // Russian MS-DO...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup. 12/08/13 at 15:48:30

Re:Re:incorrect display of cyrillic symbols in table view

Thank  you for help. Your information was very useful. I've corrected my problem and now the program is working in the right way.Sincerely your, Guller E.L....

Product: Dataease [{8}]FIVE. Written by gel63 12/08/13 at 16:34:17

Floating Currency Symbols

Is it possible to have a floating currency symbol associated with a numeric field such that the field will display £0.00 or £345.67 etc depending upon the numeric value?This is rather than showing the currency symbol separately and sometimes so...

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

Re:Floating Currency Symbols

Download Sample No username and password, simply click OK. If this was to be done properly it would need to be a change to th...

Product: Dataease [{8}]FIVE. Written by DataEase 11/12/13 at 18:34:32

On the blog about Symbols