Don't think so Tom as the syntax implies a User folder (the tilde character).
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
November 01, 2017, 02:11 PM
Doug
Are "Puppies" and "~thomas.fxxx" really part of the fully qualified path (FQP)?
November 01, 2017, 02:13 PM
Doug
Thanks Tony,
quote:
Actually Doug, you can, but you need the .EVAL
I like it
You probably covered this in your "We Can Do That In WebFOCUS" presentation at Summit, right?
November 01, 2017, 02:15 PM
Tony A
@Tomsweb,
The usual suggestion, which I am sure you've already done, is to right click the fex in question and look at the properties to get Dougs "FQP".
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
November 01, 2017, 02:16 PM
BabakNYC
I was pretty sure -MRNOEDIT is when you want to include a fex from the server app directory not from the repository. I think based on the name in this example the included focexec (IBFS:/WFC/Repository/Puppies/~thomas.fxxx/Fxxx/EURORC.fex) is in the repository.
WebFOCUS 8206, Unix, Windows
November 01, 2017, 03:09 PM
j.gross
It used to be the case that an -INCLUDE directive for a repository fex file cannot contain amper variables. As far as I know, that is still the case.
The reason involves the interplay of Client and Server:
The lookup of the fex in repository occurs within Cient; the -INCLUDE is never seen in that form by the Server. And Client has no clue what to do with "&WHCHFEX.EVAL"; at that point it probably leaves it to be passed to Server as is, and of course Server (after the amper substitution) cannot find the fex (since it has no access to repositiry).
You need to have separate -INCLUDE directives for each of the fex files, each explicitly naming the fex file and its location within Repository -- and provide -GOTO logic to send control to the -INCLUDE that matches the amper variable, when executed on Server. (By the time Server sees the request, each of the fex files will have been uploaded to Server as a temporary file, and each of the -INCLUDE lines will have been rewritten to refer to the corresponding temp file on the server).
- Jack Gross WF through 8.1.05
November 01, 2017, 04:56 PM
Tomsweb
Hi guys, thank you for your help.
I made some changes to the fex, and it is posted below:
-SET &ECHO = ALL;
-SET &OPT = 1;
-TYPE OPT = &OPT
-SET &WHCHFEX = IF &OPT EQ 1
- THEN '-INCLUDE EURORC.fex'
- ELSE '-INCLUDE JAPANRC.fex';
TABLE FILE CAR
PRINT CAR MODEL RETAIL AS 'RETAIL' DEALER AS 'DEALER'
AND COMPUTE PROFIT/D7 = RETAIL - DEALER;
BY COUNTRY
&WHCHFEX.EVAL
END
It runs now but I get a report with every country not the select few that I would expect to see if the –INCLUDE(D) Where statement were recognized and executed.
Yes, BabakNYC, thank you for pointing out that the EURORC.fex and ASIARC.fex are resting cozy and warm in the repository.
But as you say Jack Gross, it appears that the –INCLUDE is never seen by the server. Per your reference to having “separate –INCLUDE directives for each fex file (w/ –GOTO logic, could you provide a basic example?
It is very interesting that –INCLUDE functionality in FOCUS has been around since at least the 1980’s, but client server technology serves as the albatross.
An obvious caveat: The GUI's editor will totally choke on a TABLE request that encompasses dialog manager (-GOTO or -INCLUDE) directives, or even labels. So if policy requires GUI-editor compatibility, you cannot go there.
In the case of simple WHERE phrases, you can achieve the effect (within the bounds of GUI-accepted syntax) using &vars that evaluate to a target value-list or _FOC_NULL.