Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Amper in a drilldown value
Go
New
Search
Notify
Tools
Reply
  
Amper in a drilldown value
 Login/Join
 
<Pietro De Santis>
posted
I have a fex with a drilldown that passes several values. One of them contains an amper (e.g. &COM PANY=A&M). In the hyperlink URL, this gets translated to &COMPANY=A%26M. But in the drilldown program I get the following error:

(FOC295) A VALUE IS MISSING FOR: M

What can I do? Is the only solution CTRANing the & for something else?

Thanks,

Pietro.
 
Reply With QuoteReport This Post
<Pietro De Santis>
posted
Sorry, jumped the gun there!

I had coded some dialog manager using .EVAL to avoid a bunch of extra apostrophes, this was causing the error.

When the DM variable value contains a &:

BAD:

-SET &SEL1 = IF &COMPANY EQ '' THEN '' ELSE 'WHERE COMPANY EQ ''&COMPANY.EVAL''';


GOOD:

-SET &SEL1 = IF &COMPANY EQ '' THEN '' ELSE 'WHERE COMPANY EQ ''' || &COMPANY || '''';
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Don't know if this will work, but we've had instances where we wanted an '&' used in a report or heading and had to fake out with a default value:

-DEFAULT &T = &T
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
Well, even the escape char probably won't work for you because the & in a drilldown signals a new variable.
I think your best bet is that CTRAN from a 38 to a 43 (you're in ascii?) or a 80 to a 78 if you're in ebcidic. That's a + sign.

uh.. you just changed from a drilldown problem to a filter problem. ... so ignore me. Big Grin
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Amper in a drilldown value

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.