Function::String
Lower 
Lower(TEXT VALUE)
Lower("My Camel Case TEXT)
Lower("MY CAPITAL TEXT")
Lower(MyTextField)
The lower function converts each letter in a specified text value into lower-case type.
Parameters
TEXT VALUE
The Text String that you want to change to lower case.
Returns/Result
The specified text value with all the letters in lower case.
Examples
Examples
lower( "DataEase" )
Returns: dataease
lower( "Club ParaDEASE" )
Returns: club paradease
lower( LAST NAME)
Returns: The value in the LAST NAME field in lower-case type for every record that is processed. If a record contains the value Birnbaum in the LAST NAME field, the function returns birnbaum.
Reference
lower
Type
Text Function
Purpose
The lower function converts each letter in a specified text value into lower-case type.
Syntax
lower( TEXT VALUE)
Returns
The specified text value with all the letters in lower case.
Examples
lower( "DataEase" )
Returns: dataease
lower( "Club ParaDEASE" )
Returns: club paradease
lower( LAST NAME)
Returns: The value in the LAST NAME field in lower-case type for every record that is processed. If a record contains the value Birnbaum in the LAST NAME field, the function returns birnbaum.
On the forum about Lower
DataEase 8.1 is slower than 6.52 when I save a big table
I'm doing some testing on Dfw
8.1.1.1464 now, I'm just comparing this version with dfw 6.52.Ho an application
with
a table with 900,000 records with many fields and virtual. This application has
been migrated to the version 8.1 DFW Well i...
Product: Dataease [{8}]FIVE. Written by Marco 18/02/14 at 09:49:30
Re:DataEase 8.1 is slower than 6.52 when I save a big table
Hi Marco.
1. If you are doing this on a local
drive (c:/d: etc) the problem is most likely that you run Shared Local Database
in 8.1 when 6.x is running Single User mode. This means that DE8 is running
locking operations on local drive, w...
Product: Dataease [{8}]FIVE. Written by DataEase 18/02/14 at 09:50:33
DataEase 6.5-- to 8.5, migrates but it's much slower
We want to move to 8.5, but every time we download a trial version and run it with our existing data we have something that is slow slow slow. Reports that give results immediately with the old software, take minutes t...
Product: Dataease [{8}]FIVE. Written by Bonnie Clarke 21/11/16 at 18:20:40
Re:DataEase 6.5-- to 8.5, migrates but it's much slower
Hello there,I have already made the change some time ago. I could not, however, notice this problem. Rather, on the contrary, many functions are much faster than before! Maybe one would have to check the existing scripts if small traps...
Product: Dataease [{8}]FIVE. Written by grohmann.papier@t-online.de 21/11/16 at 18:39:50
Re:Re:DataEase 6.5-- to 8.5, migrates but it's much slower
I sure wish we did not have the problem, but we do. I hope someone has a lead for us to follow, to fix it. It's not just one report, but everything we have tested....
Product: Dataease [{8}]FIVE. Written by Bonnie Clarke 21/11/16 at 21:20:25
Re:DataEase 6.5-- to 8.5, migrates but it's much slower
HiHave done similar migrations, and performance was never an issue. On the contrary is gets a lot better......I would try Remove the indexes on each form, save form, re-open again and rebuilt indexes. You sai...
Product: Dataease [{8}]FIVE. Written by Josef Vella 22/11/16 at 11:00:31
Re:Re:DataEase 6.5-- to 8.5, migrates but it's much slower
The problem is that between 6.x and 8.0 there is a version called 7 which have a lot of behaviour changes which made it close to impossible for DFW 6.x users to migrate to 7.x without a lot of work.We have done a lot in 8.x do improve the migr...
Product: Dataease [{8}]FIVE. Written by DataEase 23/11/16 at 16:17:25
On the blog about Lower
Register
Sign In
