Is there a way to obtain values out of a FOCUS query, display them in a Javascript window with the ability for the user to select one of the options in the window, and then pass that value back to FOCUS?

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

Yes.

You may wish to provide more detail of what you'd like to do.

You can write a WebFOCUS program (fex) that runs another WebFOCUS program that contains HTML and JavaScript. The HTML and JavaScript in this second program can call a third WebFOCUS program, passing the selections.

Are you talking about parameters for the WebFOCUS job ?

If so there is a lot about Autoprompt.

You cna also build your own launch page. A little HTML and Javascript knowledge would be needed.

As you are on WebFOCUS 5.1 your options are limited.

Francis, you are too quick.

Or is it I spent too much time fixing my spelling errors.

quote:

fixing my spelling errors

You cna also

Really?

I did not see that "5.1" version!

I wonder if a spell check could be added to the forum ?

As for 5.1, all the calls should still be the same, things like Autoprompt will be very simple.

I think an HTML page in a Fex is the best way to go.

Are there any more spelling errors ?, I think my fingers have dementia.

This is the code I am trying to modify.

TABLE FILE PASSWORD
PRINT FILE_NAME USER_TYPE USER_ID
WHERE USER_ID EQ '&WF_REMOTE_USER';
ON TABLE HOLD AS SECURITY
END

-IF &LINES GT 0 GOTO KEEPGOING;

-*
-* HTML page displayed if WF_REMOTE_USER is not in the authorization database
-*
-HTMLFORM BEGIN

You are not authorized to access this application.  Please contact Mike Miles for authorization.

-HTMLFORM END

-EXIT

-KEEPGOING

-SET &FILE_NAME = ' ';
-SET &USER_TYPE = ' ';
-SET &USER_ID = ' ';
-SET &FILLER = ' ';

-READ SECURITY &FILE_NAME.A05. &FILLER.A03. &USER_TYPE.A04. &USER_ID.A08.

SET PERMPASS = '&FILE_NAME'

-* Changed from APP APPENDPATH NFIP to APP PATH baseapp NFIP to prevent
-* concatenation of an additional "NFIP" to the APP PATH each time a drill
-* down was done.

-*APP PATH baseapp NFIP

APP APPENDPATH data

There are multiple records in the PASSWORD file for the same USER_ID each with a different type of access to the data. I want to be able to display them all on a screen or in a Javascript window and allow the user to select what identity they want to use during the particular session.

If you require help with your code, please modify your posting, adding

[code]

at the top and

[/code]

at the bottom of your code.