Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Samir H.
  Where is Samir H.?
 Yogyakarta
 Indonesia
 Samir H.
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: how to get attendance
Thread ID: 311023 Message ID: 311029 # Views: 42 # Ratings: 0
Version: Visual FoxPro 6 Category: Forms
Date: Tuesday, June 28, 2011 10:51:24 AM         
   


> > hi Experts!
> >
> > i want to prepare attendance application please guide me which method i use?
>
> We have been doing attendance type applications for years and I must say that it is not as easy as that sounds. What exactly are you asking? From experience:
>
> -Do not try to store in and out times as separate date and time values but datetime values.
> -Do not try to make SQLs based directly on comparison of those datetime values (UNLESS the back end is not something like MS SQL Server - and if possible use MS SQL from the start)
> -Although it may look strange (and if backend is something like MS SQL) consider having calculated columns storing the in-out times as seconds.
> -Design well what would you do with records that are close enough to be not in-out but multiple entries of in or out (ie: card swiped N times thinking it is not read)
>
> and the list goes on. These are the ones that came to my mind at once. Maybe you should ask more specific questions.
>
> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> My Blog
> Blog (mirror) - sounds to be down


Hi Cetin
> -Although it may look strange (and if backend is something like MS SQL) consider having calculated columns storing the in-out times as seconds.
Did you mean calculate it at the time of clock-in/out? I'm interested to know why, if you could give an example. Thanks.

Regards
Samir

ENTIRE THREAD

how to get attendance Posted by SHAHERYAR RASHED @ 6/28/2011 10:23:06 AM
RE: how to get attendance Posted by Cetin Basoz @ 6/28/2011 10:45:30 AM
RE: how to get attendance Posted by Samir H. @ 6/28/2011 10:51:24 AM
RE: how to get attendance Posted by Cetin Basoz @ 6/28/2011 11:24:02 AM
RE: how to get attendance Posted by Samir H. @ 6/28/2011 2:06:37 PM
RE: how to get attendance Posted by Mike Gagnon @ 6/28/2011 12:01:06 PM