Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » apropiate trigger
apropiate trigger [message #77276] Sun, 16 January 2005 09:36 Go to next message
musa
Messages: 1
Registered: January 2005
Junior Member
i want to add a trigger to check if the value of the item ( which is pk) have been entered before or not,
before commiting
Re: apropiate trigger [message #111879 is a reply to message #77276] Mon, 21 March 2005 08:10 Go to previous messageGo to next message
TSN01
Messages: 3
Registered: March 2005
Location: Paloncha
Junior Member

hi musa,

i just saw ur message,

in the post-text-item just do this

select count(*) into variable from tablename where col=:block.item;
if variable >0 then
Message('There exits a value');
end if;
bye.
Re: apropiate trigger [message #111915 is a reply to message #111879] Mon, 21 March 2005 15:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
TSN,
the question is trivial.
>>i want to add a trigger to check if the value of the item ( which is pk) have been entered before or not,
If there is a PK defined on the column, it will NOT allow any duplicates.
Re: apropiate trigger [message #112109 is a reply to message #111915] Wed, 23 March 2005 01:49 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I'd say: fill it yourself (using a DB trigger and a sequence) and don't allow users to mess with it.

MHE
Previous Topic: No response from AS
Next Topic: Deploy Oracle Forms with 9I IAS and Oracle RDB
Goto Forum:
  


Current Time: Sat Feb 24 14:33:59 CST 2024