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.

Can you post the upcase code and the error message? That will help us figure it out.

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"

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.

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

RB, thanks for the post. What you did worked fine for my FEX. Appreciate it :-)

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>,

ooooohhhhh. I LIKE IT!
THANKS TOM.