[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.