Home » Developer & Programmer » Forms » Automatic Trigger fire (Oracle 9i,developer 6i)
Automatic Trigger fire [message #315983] Wed, 23 April 2008 07:14 Go to next message
imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad
Member

hi everyone

i m in the middle of implementing attendance system which will calculate daily attendance of all the employee.

I am looking for a trigger (forms level) which will automatically fire at some specific time i-e 12:00 or xx:yy.

for marking Absent for all the employees who didn't put his attendance.

Any help will be appreciated.
Re: Automatic Trigger fire [message #315987 is a reply to message #315983] Wed, 23 April 2008 07:33 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
Look at DBMS_SCHEDULER.

[edit - added]

This does not run in a FORM and I don't see what is the point of running a job in a form as it makes no sense.

[Updated on: Wed, 23 April 2008 07:34]

Report message to a moderator

Re: Automatic Trigger fire [message #315989 is a reply to message #315983] Wed, 23 April 2008 07:38 Go to previous messageGo to next message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
user the timer object for this

or

use another option for marking absent

By default . mark absent of all employees and when any emplyee's attendance is marked, it should update the attendance status from absent to present.

ok bye

Athar
Re: Automatic Trigger fire [message #316113 is a reply to message #315989] Wed, 23 April 2008 16:11 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In my opinion, Joy Division is right. Form just isn't the right tool to do that, but a scheduled (database) job is.

Timer? Right, but - imagine a system which has to have a form (that, "timer" form) open all day long in order to fire at some time of a day. Nonsense, if you ask me.

Use DBMS_JOB or DBMS_SCHEDULER and mark these employees on a database level. View who's absent in a form (or use a report).
Re: Automatic Trigger fire [message #316919 is a reply to message #316113] Mon, 28 April 2008 20:14 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Or send an email.

David
Re: Automatic Trigger fire [message #349148 is a reply to message #316113] Fri, 19 September 2008 02:08 Go to previous message
ka_wish
Messages: 85
Registered: October 2007
Location: karachi
Member

am developed attendance system in oracle developer
perfectly run im happy secess to my project.
if you are require attendace barcode system then


contact me rizwanadmani@gmail.com
thanks
Rizwan Admani
Previous Topic: maximum number of items in a data block
Next Topic: how to make users through interfaces in developer6i
Goto Forum:
  


Current Time: Wed Dec 07 03:14:43 CST 2016

Total time taken to generate the page: 0.05351 seconds