Focal Point
code unique characters in WHERE statement

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9271046582

May 27, 2008, 10:00 PM
Tomsweb
code unique characters in WHERE statement
I have coded a where statement like this:

DFINE FILE PMTRACKING
CORRECT/I5 = IF INDCODE EQ 'ETCrelatecx' AND ANSWER EQ 'Y' THEN 1
ELSE IF INDCODE EQ 'H&Pcompletew/in2w' AND ANSWER EQ 'Y' THEN 1
ELSE 0;
END

When I run the FEX, I get an html page prompting for input
To get around this error, I have coded

ELSE IF INDCODE CONTAINS 'Pcompletew/in2w' AND ANSWER EQ 'Y' THEN 1...

Any ideas for how I can use escape characters to test for the
'H&Pcompletew/in2w'?

Thanks! Confused


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
May 28, 2008, 02:29 AM
Tony A
Tom,

For the ampersand character you should separate it from the following character by using a single "pipe" - soft concat - character as in 'H&|Pcompletew/in2w'. The same method may work if you are having trouble with the slash, but I am not so sure.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10