Home » Developer & Programmer » Forms » help with trigger
help with trigger [message #424021] Tue, 29 September 2009 23:00 Go to next message
rad1cal
Messages: 2
Registered: September 2009
Junior Member
i'm only new to oracle and i want to make a trigger that will check the value of a textfield or will ask for a password before it will delete a row.
for example, i want to delete a transaction from transaction table but i will be ask to enter a password before i can delete the row..

thanks in advance.
Re: help with trigger [message #424028 is a reply to message #424021] Tue, 29 September 2009 23:54 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
Quote:
i want to make a trigger that will check the value of a textfield


Use when validate item trigger.

Quote:
i want to delete a transaction from transaction table but i will be ask to enter a password before i can delete the row


Use On delete trigger.


Re: help with trigger [message #424029 is a reply to message #424028] Wed, 30 September 2009 00:00 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
I would like to advise you to read about all the triggers. There is a inbuilt help library and apart from it, there is a lot of reading stuff available on the net.
Re: help with trigger [message #424031 is a reply to message #424021] Wed, 30 September 2009 00:29 Go to previous messageGo to next message
rad1cal
Messages: 2
Registered: September 2009
Junior Member
how do i get the value of the password field so i can compare it to the password
Re: help with trigger [message #424049 is a reply to message #424031] Wed, 30 September 2009 01:30 Go to previous message
shaz
Messages: 182
Registered: June 2009
Senior Member
Just use select query.

Is this your first form??
Previous Topic: Tirggers Execution
Next Topic: Check boxes
Goto Forum:
  


Current Time: Sun Sep 25 14:32:09 CDT 2016

Total time taken to generate the page: 0.06053 seconds