Joined: 21 Nov 2009 Posts: 58 Location: California
What exactly is the problem?
If the database contains lowercase text, then the flat file will contain lowercase text. Natural doesn't automatically convert text in a database field.
If the database contains uppercase text, then you can translate it with an EXAMINE statement.
EXAMINE #TEXT TRANSLATE INTO LOWER CASE
Is lower case content of a database field placed in a modifiable field of a map? Is the map field defined with upper case translation?
If you're having trouble specifying literals in lower case for conditional Natural code, there may be two issues.
Try the %L terminal command to tell Natural to turn off automatic upper case translation.
Enter the PROFILE command in the program editor, press PF4 for Additional Options, select General Defaults, and turn on the first two options (Editing in Lower Case and Dynamic Conversion of Lower Case).