Re: How do I retrieve free values?

From: Lars Reineke <lars.reineke_at_t-online.de>
Date: Sat, 24 Aug 2002 13:42:37 +0200
Message-ID: <ak7rdb$ci9$03$1@news.t-online.com>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message <3d6637e5$0$8505$ed9e5944_at_reading.news.pipex.net>:

>> When we know which one is free we can assign his former ID-card-number to
>> new employees who join the company.

>
> I think what Alan is getting at is that in most cases (and certainly
> yours) there is no need to worry about gaps in the sequence. There is no
> reason at all not to just use the next available number (and indeed as a
> former auditor I can think of several reasons *not* to reuse time card
> numbers).

Yes, you're surely right, but the software (and the ID-card) has been designed for a 4-digit number. I work in a hospital and so we have many employees and a rather high fluctuation. I wouldn't reuse the time card numbers either.

We only reuse them, when the former employee has left the company for at least 2 years ago, which is the time we have to store his time records.

But thank you for your advice, anyway. Received on Sat Aug 24 2002 - 06:42:37 CDT