OraFAQ Forum: Forms » Processing only when Update is done not when insert or delete

Home » Developer & Programmer » Forms » Processing only when Update is done not when insert or delete

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

Processing only when Update is done not when insert or delete [message #85461]

Tue, 29 June 2004 22:10

domingo
Messages: 54
Registered: June 2004

Member

�

I have to develop a form

This form is meant to be used only for update of existing data.

internal processing is to take place only when update happened and

it should� not let user to do any inserts or deletes.

How to go about that ?Its urgent

Please tell me elaborately .

thanks

� DOMINGO

Report message to a moderator

Re: Processing only when Update is done not when insert or delete [message #85464 is a reply to message #85461]

Wed, 30 June 2004 01:59

Tak Tang
Messages: 142
Registered: May 2004

Senior Member

Call up the block properties. There are seperate options to disallow insert and deletes.

Report message to a moderator

Re: Processing only when Update is done not when insert or delete [message #85488 is a reply to message #85464]

Fri, 02 July 2004 00:41

prashant
Messages: 122
Registered: September 2000

Senior Member

Instead of handling it from front-end u can get that be just making Roles in Oracle and only giving Update rights!!!!!

Hope it helps
Prashant

Report message to a moderator

Re: Processing only when Update is done not when insert or delete [message #85500 is a reply to message #85461]

Fri, 02 July 2004 05:10

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

you wrtie triggers on delete and insert
and use RAISE_APPLICATION_ERROR.

but form side validation also be there.

by
vamsi

Report message to a moderator

Previous Topic:	unique and interseting problem in form
Next Topic:	Passing a query from a form to a report on web

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 06 13:47:58 CDT 2024