Creating a Login screen (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 25 DEC 2005 10:38:35AM Chang Lee Churn wrote:

AREV Specific

My AREV user have requested for to create login screen for a certain menu item. My current idea is that once the user selects menu item A,

a login screen will appear. prompting the user to SELECT the available user names and key in the password.

I have created a table RM_USER_ACC with following fields.

Field Name Data Type

User_Name Character

Password Character

I have also created a login screen /window , named , SCR_USER_LOGIN

Right now , I have successfully making the user only able to select

the usernames that available in RM_USER_ACC table.

Unfortunately, the password also appears in the password field on the SCR_USER_LOGIN.

My questions are

1) How can make the password field in the SCR_USER_LOGIN to be empty?

2) How should write a program to verify the password typed in the SCR_USER_LOGIN is the same as the RM_USER_ACC password field?

3) Is my solution correct?

At 27 DEC 2005 11:00AM Matt Sorrell wrote:

Chang,

It sounds like you created a table-bound window. Instead, create a collector window. For the User Name field, set the validation to VeriFile and force it to validate from your user account table.

Since it is a collector window, nothing will populate in the Password field once a User Name/ID is selected. They can then enter the password there. Once they have saved the window, your routine would validate that the password entered matches the password on file for that account.

Also, this means that you will most likely need to write a subroutine for the login process instead of calling the window directly. This subroutine would call the window and then validate the password against the selected User Name after the fact.

Hope this helps,

msorrel@greyhound.com

Greyhound Lines, Inc.

At 28 DEC 2005 04:54AM Chang Lee Churn wrote:

Thank you for your help, Matt. I used the POPUPS instead to show the user names that are available in the RM_USER_ACC table.Somehow the I can't get the Verifile to work.

But, whatever I typed something in the Password field, is still displayed on screen. Is there any work around for this problem?

At 28 DEC 2005 06:50AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Set the foreground colour to the background colour.

The Sprezzatura Group

World leaders in all things RevSoft

View this thread on the forum...