OraFAQ Forum: Weblogic & Application Server

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » apropiate trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

apropiate trigger [message #77276]

Sun, 16 January 2005 09:36

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

Report message to a moderator

Re: apropiate trigger [message #111879 is a reply to message #77276]

Mon, 21 March 2005 08:10

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.

Report message to a moderator

Re: apropiate trigger [message #111915 is a reply to message #111879]

Mon, 21 March 2005 15:52

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: apropiate trigger [message #112109 is a reply to message #111915]

Wed, 23 March 2005 01:49

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 23:13:22 CST 2024