Home » Developer & Programmer » Forms » BARCODE READER PROBLEM
BARCODE READER PROBLEM [message #215885] Wed, 24 January 2007 03:07 Go to next message
sweetkhaliq
Messages: 200
Registered: April 2006
Senior Member

Dear
We have made the payroll system in which attendance is made by scanning the card. I want to trace out those employees who enter there code by keyboard with out scaning employee card.
I am using Oracle 8.1.7 and Forms 6i.
Please Tell me How i can trace out the employees that enter employee_id by keyboard.

Thanks and Regards
Re: BARCODE READER PROBLEM [message #215891 is a reply to message #215885] Wed, 24 January 2007 03:30 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This might be one way to do it: along with employee's ID, include additional identifier ("barcode scanner", id_type varchar2(2) = 'BS') to the barcode. Insert emp_id into emp_id column and 'BS' into id_type column.

So, if employee types ID using the keyboard, id_type column will be NULL.
Re: BARCODE READER PROBLEM [message #215901 is a reply to message #215891] Wed, 24 January 2007 04:27 Go to previous messageGo to next message
sweetkhaliq
Messages: 200
Registered: April 2006
Senior Member

Ok i now that this can be done by adding additional identifier in database column like "BS" for Barcode Scanner. But problem is that How i verify that Card is enter by Barcode Scanner or Keyboard. Which Trigger could distinguish between enter code by barcode scanner or enter code by keyboard. Please tell me in detail.
Thanks for reply
Re: BARCODE READER PROBLEM [message #215908 is a reply to message #215901] Wed, 24 January 2007 04:40 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No trigger. Barcode should have that information in it (and insert 'BS' into an item which is not accessible by keyboard).
Re: BARCODE READER PROBLEM [message #298670 is a reply to message #215908] Thu, 07 February 2008 01:28 Go to previous messageGo to next message
ka_wish
Messages: 87
Registered: October 2007
Location: karachi
Member

if your required attendance system from oracle then purchase me
i desgined attendance system
thanks
Rizwan Admani
0300-2421292
Re: BARCODE READER PROBLEM [message #298758 is a reply to message #215885] Thu, 07 February 2008 09:16 Go to previous messageGo to next message
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
Senior Member
My dear you are looking in the wrong place. Your attendance machine should be having a software/interface of its own. Check there. Normally the data has a readtype which lets you know how the record has been authenticated. Use that. For oracle, unless you have this field, the data is going to be alike.
Re: BARCODE READER PROBLEM [message #298829 is a reply to message #298758] Thu, 07 February 2008 22:45 Go to previous message
ka_wish
Messages: 87
Registered: October 2007
Location: karachi
Member

dear frind i create a attendance system in barcode machine
and after 2 year runing status
sucessfuly runing attendance system
thanks
regards
rizwan admani
Previous Topic: Scroll Bar Form window
Next Topic: FRM-92101 FAILURE FORM SERVER
Goto Forum:
  


Current Time: Sun Feb 16 00:41:08 CST 2025