[CLOSED] UPCASE in Diaglog Manager

July 21, 2011, 09:10 AM

Why does this code not work as it should?

-SET &LOOKUPVAL = 'Walk';
-TYPE BEFORE &LOOKUPVAL.LENGTH
-SET &LOOKUPVAL = UPCASE(&LOOKUPVAL.LENGTH,&LOOKUPVAL,'&LOOKUPVAL.LENGTH');
-TYPE AFTERC &LOOKUPVAL.LENGTH

-TYPE &LOOKUPVAL

So, it looks like the UPCASE function is adding 13 characters to the length of my variable? I suspect I'm going to be told that I should SUBSTR it, but this is frustrating.

Or more to the point, how should I be upcasing a DM var? I will be passing it to a WHERE statement.

- ABT

This message has been edited. Last edited by: ABT,

------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro

July 21, 2011, 09:49 AM

Francis Mariani

The syntax requires a format for the output, not just a length:

-SET &LOOKUPVAL = UPCASE(&LOOKUPVAL.LENGTH,&LOOKUPVAL,'A&LOOKUPVAL.LENGTH');

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

July 21, 2011, 09:55 AM

ABT

quote:
Originally posted by Francis Mariani:
The syntax requires a format for the output, not just a length:

-SET &LOOKUPVAL = UPCASE(&LOOKUPVAL.LENGTH,&LOOKUPVAL,'A&LOOKUPVAL.LENGTH');

Missed it by that much!

Thanks Francis!
- ABT

July 21, 2011, 11:48 AM

Francis Mariani

There's an 'r' missing in your sig! Glad to be of service!

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

July 22, 2011, 08:36 AM

ABT

quote:
Originally posted by Francis Mariani:
There's an 'r' missing in your sig! Glad to be of service!

Fixed that, but I'll let 'Diaglog' in the subject live on in infamy...

-ABT