Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Case Conversion
 Login/Join
 
RB
Gold member
posted
Hi,

I have a text input box in my html page and the users enter either lowercase or the uppercase. I need to pass this parameter in to WHERE statement in my FEX.


I am having trouble doing that. UPCASE is not working.
 
Posts: 76 | Registered: October 28, 2003Report This Post
George Brown
Gold member
posted Hide Post
Can you post the upcase code and the error message? That will help us figure it out.
 
Posts: 77 | Location: Chicago, IL | Registered: May 06, 2004Report This Post
RB
Gold member
posted Hide Post
Here you go...

DEFINE FILE CAR
COUNTRY1/A8 = UPCASE(8, &COUNTRY, COUNTRY1);
END

TABLE FILE CAR
....
.....
...
...
WHERE COUNTRY EQ COUNTRY1
END

when I enter country value as "england" for the amper variable, it takes the value in define, but gives me an error telling that
"field name or computational element not recognised:england"
 
Posts: 76 | Registered: October 28, 2003Report This Post
Leah
Virtuoso
posted Hide Post
Didn't run this but try putting quote marks around the & variable.
DEFINE FILE CAR
COUNTRY1/A8 = UPCASE(8, '&COUNTRY', COUNTRY1);
END

TABLE FILE CAR
....
.....
...
...
WHERE COUNTRY EQ COUNTRY1
END
Leah C.
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
RB
Gold member
posted Hide Post
Hi Leah,

The report does not work if we give the quotes.
It gives the same error as before.

I figured out anyways!

-SET &COUNTRY1 = UPCASE(&COUNTRY.LENGTH, &COUNTRY, 'A8');

-*THIS WOULD CONVERT &COUNTRY PARAMETER TO UPPERCASE AND PASS IT TO &COUNTRY1.
this way we could use it in the where statement

TABLE FILE ..

...
..
WHERE COUNTRY EQ '&COUNTRY1'
END
 
Posts: 76 | Registered: October 28, 2003Report This Post
<NorthNone>
posted
RB, thanks for the post. What you did worked fine for my FEX. Appreciate it :-)
 
Report This Post
Tom Walker
Member
posted Hide Post
You can also force the case conversion at the HTML level. Assuming you are using TEXT INPUT ...

name="TEXT1"
size="6"
maxlength="6"
onChange="javascript:this.value=this.value.toUpperCase();">[/code]

This message has been edited. Last edited by: <Mabel>,
 
Posts: 26 | Location: Mercy College | Registered: May 06, 2003Report This Post
susannah
Expert
posted Hide Post
ooooohhhhh. I LIKE IT! Smiler
THANKS TOM.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders