Check if a username exists

[mcyrulik]

Hey all,

I have a solution that adds a username and a password to our DB whenever a company is added to our contacts table(whoever add the contact clicks a button). Well, when we converted from FM 6 to FM 7, and added all those accounts, some did not get added. Also, after conversion it took us a bit to realize that the script had not always been adding new users since conversion(or people have not been clicking the button).

So, is there a way to check to see if a username already exists by way of a script step?

So, now we need to find a way to check to see if a username exists before we send out an email to them, so that when they try to get in, they actually can.

Any help would be greatly appreciated.

~Mark

[Ender]

When you attempt to Add, Delete, Enable, or Disable an account, it will generate an error code if the account doesn't exist. I'd suggest you Set Error Capture [On], then try Disabling the account and checking for that error code (I can't remember what the error code was for this, but you can look it up.)

[Steven H. Blackwell]

Take a look at the Account management ScriptMaker steps for an idea of how to create an Account, enable or disable it, or to delete it.

Account names must be unique and are not case sensitive, although you should treat them as if they were.

Passwords are not unique, but they are case sensitive.

Your older method of adding "passwords" is both obsolete and counter-productive to what you're trying to do here. Use the built in FileMaker Pro system.

HTH

Steven

[mcyrulik]

I am using the built is scriptmaker steps to add accounts. What I would like to do is find some test as to whether the account already exists, and looking through the script steps of FM7, there isn't a step that says IfExists(accountname).

I would like to find a way to do this without having to try to manipulate the account in any way to have it throw an error code(such as disableit, or reset the password). Just a simple check to see if it exists.

Edited October 10, 2005 by Guest

[Steven H. Blackwell]

Doubt this is possible as you describe it. If you set out to create an Account and it does not exist, then you'll create it. If it does exist, you'll get an error. You can capture the error and manage it in an elegant fashion.

Steven