I am having a problem with my username and password entry. When it verifies the two fields it takes only a partial username or even just a first letter if the password is correct. Here is part of the script which checks the fields. It goes on to tell the user to try again. I would appreciate any feedback.

Enter Find Mode []

Set Field ["klc_staff_username", "staff_username"]

Set Field ["klc_staff_password", "staff_password"]

Perform Find []

If [status(CurrentFoundCount) = 0"

This is proper. It's the way finds work in FM. You will need to do an exact find.

Set Field (field, "=" & "username")

-bd

Thanks for your prompt reply. So I will need to list all the usernames and passwords in the calculation as aposed to finding them in the database. Excuse my "noviceness". Thanks in advance.

n

I hope you don't mind a fresh perspective.

We use a password entry system.

individuals fields

password (text)

username (text)

login details (calc text) password & ":" & username)

Three fields for checking validity

password.gl (global text)

username.gl (global text)

check login (calc text) (password.gl & ":" & username.gl)

Then a relationship confirmlogin (check login to login details)

Then your script is simple, and no find to contend with.

If (IsEmpty(password.gl) or IsEmpty(username.gl)

Show message " not all information completed"

Exit Script

End If

If (IsValid(confirmlogin::login)

GoToRelRecord(show only related)confirmlogin

Enter the rest of your standard login here

Else

Show Message "Incorrect Entry"

End If

A change of direction...to be sure!

I again want to enetr a very strong word of caution about the user log on systems. If security is your purpose in using them, be extraordinarily careful. Thre are many, many loopholes in almost every one of these systems I have ever seen. And I have seen a great number of them.

HTH

Old Advance Man

Ok so in saying that and with your experience in seeing many solutions what do you consider is the best method - do you have examples?

Greg

[ February 26, 2002, 07:23 PM: Message edited by: gwmbox ]