Home » Developer & Programmer » Forms » please help me????
please help me???? [message #138059] Mon, 19 September 2005 13:40 Go to next message
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 #138086 is a reply to message #138059] Mon, 19 September 2005 20:15 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I gave all my ideas in your other thread. Maybe someone else has other ideas.

David

[Updated on: Thu, 22 September 2005 18:36]

Report message to a moderator

Re: please help me???? [message #138497 is a reply to message #138059] Thu, 22 September 2005 05:12 Go to previous message
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.

Previous Topic: Cursor problems in Developer Forms 6.0
Next Topic: How to map key in Form 6i
Goto Forum:
  


Current Time: Fri Sep 20 05:54:46 CDT 2024