Focal Point
[SOLVED]Selecting on a value that contains "&"

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

February 21, 2012, 06:26 AM
mark66
[SOLVED]Selecting on a value that contains "&"
Hi all,

I need to setup a report version for a field whose value actually contains "&"…

Eg:

TABLE FILE TEST
PRINT *
WHERE FIELDA EQ 'AA&BB';
END
-RUN

Program fails with:

(FOC295) A VALUE IS MISSING FOR: &BB

I have tried putting the value into a &var, and using EVAL, but it still fails.

Is there a way to ignore the &er for this line of code?

Thanks

Mark

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


WebFocus 765. iSeries v5r4
February 21, 2012, 07:05 AM
Danny-SRL
  
-* File mark66_2.fex
TABLE FILE CAR
PRINT COUNTRY
IF COUNTRY EQ 'AA&|BB'
END



Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

February 21, 2012, 07:12 AM
mark66
Awesome, works great.

Thanks Danny!


WebFocus 765. iSeries v5r4