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

Unique index and BrokenRules

Jiri Brazda — Tue, 21 Apr 2009 10:56:05 GMT

Hi,

I have Unique index on some fields in tables and now I would need to inform user that he has entered duplicated value. At the moment I'm solving this problem bz calling my methods such "...IsUnique" and manually adding information about duplicity to BrokenRules collection to be handled later.

The question is simple - is it possible to force BrokenRules to handle Unique indexes?

Thank You

Jiri Brazda

RE: Unique index and BrokenRules

Jiri Brazda — Tue, 21 Apr 2009 10:56:05 GMT

Great info! I'm looking forward to next versions :)

Thanks

RE: Unique index and BrokenRules

Trent L. Taylor — Tue, 21 Apr 2009 10:39:04 GMT

This is something that is actually on the list for a future update. We added this to our BaseBO in our medical software and we will most likely incorporate this into the framework once it has been throughly tested.

RE: Unique index and BrokenRules

Jiri Brazda — Tue, 21 Apr 2009 10:30:09 GMT

Yes I'm using similar approach. I just wanted to ask whether SF can handle Unique key rules somehow automatically - just like it does with required fields - to avoid wasting time when some solution already exists...

Thank You for reply :)

RE: Unique index and BrokenRules

Greg McGuffey — Mon, 20 Apr 2009 12:10:40 GMT

I've done a couple of things to handle unique index issues, the best being to handle it in the CheckRulesOnCurrentRow event handler of the BO.

In the event handler, I call another method to check if the data would violate the unique index, usually a sproc. If the data would violate the unique index, I then setup broken rules for the fields the user can change to fix the issue.

Hope that helps! :D