Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Shaheryar Rashed
  Where is Shaheryar Rashed?
 Multan
 Pakistan
 Shaheryar Rashed
 Tags
Subject: RE: how to get attendance
Thread ID: 311023 Message ID: 311028 # Views: 52 # Ratings: 0
Version: Visual FoxPro 6 Category: Forms
Date: Tuesday, June 28, 2011 10:45:30 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

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