[AccessD] Quarter hour increments

Gustav Brock Gustav at cactus.dk
Mon Oct 24 07:16:07 CDT 2005


Hi Scott

That's right, but you were suggesting validation at the table level. Validation in a business layer is, of course, preferable and logical as it would not be an error at the table level to store a value with a count of minutes of, say, 10 in a date/time field.

However, my point is another. Wherever the "error" is caught it should not raise an error. Error messages bother users, indeed in situations where the user will think "stupid application, when I type 12 minutes, why doesn't it just round that to 15?". Thus your business rule should catch this "error" silently, and gently and/or quietly guide the user to the desired input which - according to your business rule - in this case would be to round up, down, or to closest quarter of an hour.

I think it is worth the fuzz. Details like these handled in a way that has the user in focus add quite a lot to the total user satisfaction. 
Also - and that's important - when you care for the details, the client (the user) automatically will think that if the details are taken properly care of, so are the big tasks. 

/gustav

>>> marcus at tsstech.com 24-10-2005 13:24 >>>
Gustav,

With all respect, I was just giving options. My opinion is that this
belongs in a business layer, separate from the backend or front end.
Hardly seems worth all that fuss (a separate layer). Choose what is
appropriate for your situation.

Scott Marcus
IT Programmer
TSS Technologies Inc.
www.tss.com 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Saturday, October 22, 2005 5:52 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Quarter hour increments

Hi Jim and Scott

With all respect, in my opinion this is not the route to follow.
Machines should help people (users) not bother them. Thus the rounding
solution as suggested by Ken is what you should (and I do) use. Perhaps
associated by a Beep when rounding occurs ...

/gustav





More information about the AccessD mailing list