essentialdata-discuss

[Essentialdata-discuss] row-level validation

[Alex G. <lj...@gm...>]

I have some relational data in a row that I need to validate and I'm
having some trouble determining essentially how to do it. For example,
consider an MROTable that has columns for Name, Score and Max Score
and you want to validate that Score <= Max Score. What I want to be
able to do is color the row red if this criterion isn't met and color
it green if it is.

I suppose what I'd like to know is 1) is this sort of thing already
supported in ED? I seem to recall something similar in the wiki before
it went down and 2) if not, where in the code would I look to figure
out how to add something like this.

Any pointers or advice would be much appreciated.

Thanks,
Alex

Re: [Essentialdata-discuss] row-level validation

[Dave O. <dj...@co...>]

Alex Garrett wrote:
> I have some relational data in a row that I need to validate and I'm
> having some trouble determining essentially how to do it. For example,
> consider an MROTable that has columns for Name, Score and Max Score
> and you want to validate that Score <= Max Score. What I want to be
> able to do is color the row red if this criterion isn't met and color
> it green if it is.

Here's how:

Put an IValidator on the Score property that range-checks that Score < 
Max Score.

ED will let the user move around within the row (using the mouse), but 
will color the Score field yellow if it fails this validation test.  And 
it won't allow the user to move off the row entirely until all fields 
within the row (including the Score field) pass all validity tests.


Regards,

Dave Orme

-- 
Got Java?  Use db4objects! <http://www.db4o.com>

PGP Public Key (for confidential communications):
http://www.coconut-palm-software.com/~djo/public_key.txt

Re: [Essentialdata-discuss] row-level validation

[Alex G. <lj...@gm...>]

Unfortunately, I was a little simplistic in my description and my
problem was incorrectly stated. Let me try again with more detail. I
have a reasonably complicated validation model. There are eight
columns. The status of the first column determines whether the other
seven count at all. If they do, the next four need to be numbers in
monotonically non-decreasing order. The last three columns have a
mathematical relationship between themselves and one or more of the
prior four.

A use case is that a user may start by selecting a value from the
first column through a combo box and then enter values 10, 20, 30, 40
(e.g.) in the next four fields. They'll want to use the tab key for
ease of entry, but after entering 10 in the first field, the row will
no longer be valid and they'll have to use the mouse to move to the
next three fields. At this point, the row still may not be valid
because the values don't satisfy the constraints for the last three
fields.

This is why I wanted to be able to have some kind of process that
would allow them to enter in whatever data they want (subject to
syntactic constraints like ensuring the values were numbers)  and
indicate whether the data were valid or not.

One alternative that I considered was to have a column "Valid" that
would have an indicator, but the feedback I'm getting is that row
coloring is preferred. If there were a column indicator, it would have
to be an image, and I'm not sure how to pull that off, either. AFAIK,
the controls require String inputs. Any ideas?

Thanks,
Alex


On Thu, 20 Jan 2005 15:18:26 -0600, Dave Orme
<dj...@co...> wrote:
> Alex Garrett wrote:
> > I have some relational data in a row that I need to validate and I'm
> > having some trouble determining essentially how to do it. For example,
> > consider an MROTable that has columns for Name, Score and Max Score
> > and you want to validate that Score <= Max Score. What I want to be
> > able to do is color the row red if this criterion isn't met and color
> > it green if it is.
> 
> Here's how:
> 
> Put an IValidator on the Score property that range-checks that Score <
> Max Score.
> 
> ED will let the user move around within the row (using the mouse), but
> will color the Score field yellow if it fails this validation test.  And
> it won't allow the user to move off the row entirely until all fields
> within the row (including the Score field) pass all validity tests.
> 
> Regards,
> 
> Dave Orme
> 
> --
> Got Java?  Use db4objects! <http://www.db4o.com>
> 
> PGP Public Key (for confidential communications):
> http://www.coconut-palm-software.com/~djo/public_key.txt
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> Essentialdata-discuss mailing list
> Ess...@li...
> https://lists.sourceforge.net/lists/listinfo/essentialdata-discuss
>