You can use the server behavior "webassist->MySQLi->authentication->check new username"
That can be used to look for duplicate records before the insert takes place and redirect to display an error message.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.