http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Validating lookups Thu, 11 Jun 2026 06:28:20 -700 Tue, 18 Mar 2008 13:42:24 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=713 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=713&PID=2707#2707 Author: eileenv
Subject: 713
Posted: 18-Mar-2008 at 1:42pm

One way to accomplish this would be to implement a verifier that checks for foreign key values that are null. Then you can perform instance verification prior to a save and notify users of invalid data before the save occurs.]]> Tue, 18 Mar 2008 13:42:24 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=713&PID=2707#2707 http://www.ideablade.com/forum/forum_posts.asp?TID=713&PID=2635#2635 Author: antalakas
Subject: 713
Posted: 04-Mar-2008 at 2:50pm

Let 's say i build a form to handle INSERT/DELETE/UPDATE in a database table.
My table has a relation to a lookup table, and i feel like setting it to mandatory.
I follow mapping rules and implement the form.

I use the UI and insert a new record. The Create method in the object Model for my table
does not set initial value for the lookup.

In this case the lookup fills the gap with a null entity value and the form is working.

When i am trying to save a message is displayed stating that "A foreign key constraint... " etc.
As you remember the lookup was required but not set...

How can i inform my users for the inability to save BEFORE they try to press the save button?


Thank you

Andreas


]]> Tue, 04 Mar 2008 14:50:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=713&PID=2635#2635