sql - Validating Multiple Logins in vb6 -

how can code in vb6 capture exact login time of employees in system.

my system daily time records. each employee has login schedule

 8:00am - timeinam, 12:00pm - timeoutam, 1:00pm - timeinpm, 5:00pm timeoutpm 

i want time of employees , compute lates , undertime based login time , login schedule.

i'm concern employees has multiple logins in every session. how manage know if belong timeinam,timeoutam,timeinpm,or timeoutpm.

the structure of table have these breaktime fields in every session. here's how look:

 empid | timeinam | breakoutam | breakinam | timeoutam | timeinpm | breakoutpm | breakinpm timeoutpm | late | undertime | date | 

sql database.

any 1 me , glad. im working month now.,

example of scenarios

empid=0001 date=08-13-2013 8:00am - timeinam, 12:00pm - timeoutam, 1:00pm - timeinpm, 5:00pm timeoutpm 

on date login morning session 2times

7:57:23 7:58:10 //it happens when thinks didn't login. time in again 

he logout in morning @

12:03:01 pm 

he login in afternoon @

01:03:05 pm 

and logout @ afternoon at

05:12:27 pm 

on next scenario employee has multiple logins in session eg. happens when goes outside company transactions. should recorded undertime in morning., example is:

in morning login

7:50:12 

then undertime at

10:30:02 

and goes @

11:02:01 

and logout in at

12:02:01 pm 

in afternoon session normal login of employee done

he login at

01:05:01 pm 

and logout @

5:04:10 pm 

this of scenarios possibly happen., please comment if examples not cleared.

note: it's me determined belongs timeinam,timeoutam,timeinpm, or timeoutpm. data list of logins of every employee everyday.

not sure understand you're trying do, looks business rule handy here: if take first clock in every block of, say, 15 minutes timespan, you'll eliminate "have clocked in or not" cases.

then need associate clock-in/clock-out reason - example cases see:

• start+end of day
• start+end of break
• start+end of offsite

every system i've seen that, has way "administrator" manually override clocks, can fix missing end-of-day clocks.

if can't have reason built data you're consuming, think you'll need business rules able tell break offsite - if user clocks out between 11:30am , 1:30pm, it's lunch break; if it's after first clock before lunch break, it's offsite; if user clocks out after 4:30pm it's endofday, , clock-out before after user clocked in lunch, offsite again.

with table structure you're shooting for, you'll need update record each employee/date, every time clock in/out.

you'll need code fetch appropriate record, , update it; you'll need code determines in field you're writing clock time - code function taking clock time , validating business rules determine field - public function getfieldnameforclocktime(clocktime date) string.