OraFAQ Forum: Forms » make the form cannot be updated or insert in it

Home » Developer & Programmer » Forms » make the form cannot be updated or insert in it

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

make the form cannot be updated or insert in it [message #175709]

Mon, 05 June 2006 01:45

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

Hii all

is there any way to make my form (including all blocks in that form) cannot insert in it or cannot update in it or cannot delete in it

something like
set_block_property(block_name,update_allowed,property_false);

i want something like that
but on the level of the form

Thanks for everyone helped and helping me

Report message to a moderator

Re: make the form cannot be updated or insert in it [message #175714 is a reply to message #175709]

Mon, 05 June 2006 02:00

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Select all database blocks (at once, not separately) and change their INSERT ALLOWED / DELETE ALLOWED / UPDATE ALLOWED properties to "NO".

Report message to a moderator

Re: make the form cannot be updated or insert in it [message #175719 is a reply to message #175709]

Mon, 05 June 2006 02:34

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

I don't want the treatment to be on the level of the BLOCK

i want it on the level of the FORM

Report message to a moderator

Re: make the form cannot be updated or insert in it [message #175736 is a reply to message #175719]

Mon, 05 June 2006 03:27

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I see ... I'm not sure can it be done on a form level without programming it. Why do you refuse to use Forms built-in functionality (which can be achieved in 5-6 mouse clicks)?

Report message to a moderator

Re: make the form cannot be updated or insert in it [message #175909 is a reply to message #175709]

Tue, 06 June 2006 01:13

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

Have anyone other ideas on this issue

Report message to a moderator

Re: make the form cannot be updated or insert in it [message #175949 is a reply to message #175909]

Tue, 06 June 2006 03:23

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You can use the switch query_only=YES. This is a command line option when starting the forms runtime component. If you are using the CALL_FORM built-in to open the form you can also specify the query_only parameter. Perhaps that's an idea.

MHE

Report message to a moderator

Re: make the form cannot be updated or insert in it [message #175989 is a reply to message #175709]

Tue, 06 June 2006 05:28

Rehan Mirza
Messages: 67
Registered: July 2004
Location: Pakistan

Member

Just write trigger on form lavel

On-Insert --
On-Update --
On-Delete --

code for these trigger is
NULL;

or
on Pre-Insert --
Pre-Update --
Pre-Delete --
Code for these trigger is

Raise Form_Trigger_Failure;

Best regards
R E H A N M I R Z A

Report message to a moderator

Previous Topic:	COMPILING FORMS FROM THE COMMAND LINE
Next Topic:	TNS-03505:Failed to resolve name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:18:20 CDT 2024