I could change everything. I just don't want to :-) . I own the solution from the timeclock (programmed by me) through the Java servlet (also written by me). So, yeah, I could re-architect the whole tamale but there is an awful lot of code there....

I am not sure what the IN/OUT on the same record does for me. Here is a familiar scenario:

Policeman clocks IN at 20:00 on 7/10/2012 and then Clocks out at 01:00 on the 11th. He takes a call at 03:00 goes to the scene, does his work and gets to the office and clocks out at 06:00. He never clocked in because we went on duty without going to the station first. So he has a punch IN (at 20:00) and a punch OUT at 01:00 and another punch OUT at 06:00. This is perfectly permissible. But it gets worse if he accidentally punched IN at 06:00 am rather than OUT because he will punch IN again at 20:00 to start his shift. Now I have IN/OUT/IN/IN.

I have pretty limited tools on the timeclock itself. The even driven approach (tell me who what and when ) is the easiest to implement given the programming tools I have. I could try something more sophisticated on the clock but it will take some effort.

I was hoping to solve this on IBM i side.

Pete Helgren
Value Added Software, Inc
www.petesworkshop.com
GIAC Secure Software Programmer-Java

On 7/19/2012 2:20 PM, Charles Wilt wrote:
Pete,

Trying to work around bad data is always hard...

Much better to prevent the bad data from making it to the DB in the
first place:)

But with the structure you've got, that's hard.

Did you reply originally that you couldn't change the table to have in
and out on a single row?

Charles


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.