Focal Point
[SOLVED] Filter value with "&"

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

February 10, 2010, 05:45 PM
Gavin
[SOLVED] Filter value with "&"
I tried to create a filter in DM V768 like T2.VALUE_NAME = 'GROSS_INCOME_&_INTEREST'
but got an error when I tried to run it. Any ideas?

hc_review_stg type Oracle Existing target
Issuing PREPARE
0 ERROR AT OR NEAR LINE 76 IN PROCEDURE fct_tt_r_020
(FOC295) A VALUE IS MISSING FOR: &_INTEREST
Finished

This message has been edited. Last edited by: Kerry,
February 10, 2010, 05:59 PM
Waz
Can you change the filter value to 'GROSS_INCOME_&|_INTEREST'


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

February 10, 2010, 06:24 PM
Gavin
Nice job! It works. Thanks.