User Validation? 1

[mrDrive]

Does anyone know a simple script for validating a username and password in forms? I have set up a table with 2 colums: username and password. I trying to write a procedure or trigger to validate that the username entered equals the password for that username. This would only allow the user user to navigate to the next form and not login to the database.

I've done this before with ASP and such but I'm stumped on how to do it with Oracle forms.

Any help would be greatly appreciated.

David

 

[mrDrive]

OK well...never mind! I got it!

In case you're curious...I did it like this:

PROCEDURE VALIDATE_UNAME_PWORD IS
uname_variable varchar2(30);
pword_variable varchar2(30);
BEGIN
SELECT <username_field>, <password_field>
INTO uname_variable, pword_variable
FROM <user_info_tablename>
WHERE <username_field>= <:data_block_name>.<username_text_element>;

IF pword_variable = <:data_block_name>.<password_text_element>
THEN call_formglobal.p_path || '<next_form>.fmx');
ELSE
<execute_error_procedure>;
END IF;
END;

Woooooooh!