How to check for duplicate usernames?

Jeff Massung massung at
Thu Aug 4 11:53:44 EDT 2011

Instead of checking for a username, mark the UserName field in the table as
being UNIQUE. This will cause the DB to error out of a transaction that
attempts to insert the same UserName into the table multiple times. Then
catch that.

Jeff M.

More information about the Use-livecode mailing list