StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Sql Unique constraint

Sql Unique constraint

Nikki Chase — Thu, 20 Apr 2006 13:08:52 GMT

Hi,

What is the preffered way to handle unique constraints in SF? If I attempt to save a dupe SF returns the Big Bad Error box which is fine but I would like to give the user a little better message. For now I just added a method to check the value in the BO's broken rules method and that seems to work fine however it does mean that the check is being performed twice.

Can I trap for this exception and display an alternate message?

Thanks

RE: Sql Unique constraint

Gary Wynne — Thu, 20 Apr 2006 13:08:52 GMT

Hi Nikki,

The problem when you start working with a new framework in a new technology is that there is sooooo much to take in, even if the answer was painted across your forehead, you probably wouldn't see it :)

So, take a rest from your heavy (last) weekend of framework analysis and get ready for the coming weekend and you can start all over again :w00t:

Best

-=Gary

RE: Sql Unique constraint

Trent L. Taylor — Thu, 20 Apr 2006 10:22:44 GMT

Gary knows what he is talking about ;)

RE: Sql Unique constraint

Nikki Chase — Thu, 20 Apr 2006 09:05:09 GMT

Thanks Gary!

That makes perfect sense I just didn't see it in the docs but then again I was probably a little cross eyed.

RE: Sql Unique constraint

Gary C Wynne — Thu, 20 Apr 2006 08:19:44 GMT

Hi Nikki

From the Business Object Events Overview in the documents:-

The ErrorSaving event is raised only when an exception occurs on the server while executing a Save operation. The exception displayed here originates from the server and provides the developer with detailed information as to why the query or save operation failed. This is extremely beneficial to the developer, especially when initially programming the business objects. Since the detailed error that occurred on the server is brought all the way to the form level, this releases the developer from step-by-step debug sessions to determine why the query failed. By default, a StrataFrame form will automatically display any save errors to the end-user. To prevent this message from being displayed to the end-user, the AutoShowSavingErrors property on the form must be set to False.

So, you can test and handle the ErrorSaving event and surpress the big-bad error by setting the AutoShowSavingErrors property to false.

HTH

-=Gary