Focal Point
[SOLVED]Selection through parameters fails for some machines

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

January 27, 2009, 05:00 AM
minos4
[SOLVED]Selection through parameters fails for some machines
The following issue happens only to some machines so I guess it's not a coding error.

Even the simplest selection:

TABLE FILE CAR
PRINT CAR
WHERE SEATS EQ &SEATS;
END


gives error message:
(FOC295) A VALUE IS MISSING FOR: &SEATS

Version is not the issue. We had 766 on some machines and 764 on others, while the error message pops up under both versions. And the rest that works also contain both versions.

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


____________________
764_XP
January 27, 2009, 06:05 AM
nubi
quote:
&SEATS


It is a coding error if you haven't defined &SEATS


Try entering at the top of the statement:

 -SET &SEATS = '1'; 


it may be that you are trying to run it from another .fex or caster job which means its not prompting you to enter a value for &SEATS. normally when you don't define a variable it will prompt you for it


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
January 27, 2009, 06:39 AM
Tony A
Do you have user profiles that skip amper autoprompting for some users? or is it the same Id being used on different machines?



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 
January 27, 2009, 07:56 AM
minos4
Tony, thanks for the tip. I think it is the amper auto-prompting issue.
I tried to search help file for information, but it just says "Select Configuration -> Select Managed Reporting -> Set IBIMR_prompting" (whici is nowhere to be found), and refers to "WebFOCUS Security and Administration manual".


____________________
764_XP
January 27, 2009, 08:22 AM
nubi
Is the report in MRE? try right-clicking it in DS and looking at the properties


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
January 27, 2009, 08:27 AM
Tony A
IBIMR_prompting can be found via the Client server console (http://[your server]/ibi_html/wfconsole.htm).

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 
January 27, 2009, 08:33 AM
minos4
Yeah, my mistake, it's under administration console. Thought it was just some DS setting, forgot it was security.
Thanks, problem solved.


____________________
764_XP