please help me???? [message #138059] |
Mon, 19 September 2005 13:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ribha
Messages: 17 Registered: August 2005 Location: pakistan
|
Junior Member |
|
|
hello sir,
i am working on "Attendance system" and
uses RFID for attendace
there is a problem with it
how can i check is the card id is valid or not when employee left organization ???
i want to search or match the card id with the record in database (a large database) at the attendance time.
how can i implement binary search for that problem??
or what solution you suggest for this problem
please help me ???
|
|
|
|
Re: please help me???? [message #138497 is a reply to message #138059] |
Thu, 22 September 2005 05:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
avinash_ess
Messages: 4 Registered: September 2005 Location: Mumbai
|
Junior Member |
|
|
Hi,
It's very tough to validate a record from binary file.
Workaround - You can temporarily take all the records to a Temp_Table before actual import to attendance table.
Basically DO this whole process in 2 steps.
Step 1. Get the Binary file to Temporary Table.
Step 2. Process Temporary Table with a join condition to active employee list and only transfer the record of a active emp to atendence table.
Hope it will work.
|
|
|