Ginny is the winner. The second big difference is dealing with blanks in the values that are in the external file being used in the selection statement.

Try running the following example one with the IF statement and then again with the WHERE clause. you will see that the WHERE clause fails due to the fact that W GERMANY has a blank in the value. The IF statement will work just fine.

TABLE FILE CAR
COUNT CAR NOPRINT
BY COUNTRY
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE AS 'COUNTRY'
END
-RUN

TABLE FILE CAR
SUM CNT.CAR SALES
BY COUNTRY
IF COUNTRY EQ (COUNTRY)
-*WHERE COUNTRY IN FILE COUNTRY
END

Well, this proves that I read documentation. I in fact have that whole discussion flagged in my hardcover manual.

Give me a little while to come up with a new question.

I am a WebFOCUS admin for a bunch of business unit developers and, other than passwords, the majority of questions are about application pathing. So let's play admin.

Assumptions

1. Secure WebFOCUS Reporting Server
2. Browser apps run under a default id if there is no logon.
3. Self-service
4. The master is not in the focexec directory.
5. Do not assume that the master directory is in edasprof.prf

How do you tell your developer to:

1. Access the master from Developer Studio tools.
2. Access the master when the program is run from the browser.
3. Access the master for a dynamic pulldown.

Though this is not a difficult question, maybe getting the answers here all in one place will help a future poster.